aws / aws/aws-cdk

redshift: Redshift User Groups

Open
#25,394 1 comment 0 reactions 0 assignees View on GitHub
@aws-cdk/aws-redshift effort/medium feature-request p2
Dominant language
TypeScript
Stars
12.9k
Forks
4.6k
Avg merge
2d 3h
Merged PRs (30d)
83

Description

### Describe the feature

Add an API for creating Redshift User Groups

### Use Case

Sometimes, infra developers may not need to create individual users, but entire groups, and then manage and maintain access to these groups through the Redshift Console.
If there are a vast number of users within a Redshift Data Warehouse, managing them within a single CDK application may be cumbersome, so these can be managed through a minimal amount of user groups, which can then be managed through the Redshift console, etc.

### Proposed Solution

Add a separate API within the Redshift Construct to access and maintain a group of `Redshift.User`. The Redshift Data API allows the execution of SQL code, which also includes the addition of running `GROUP` commands. Therefore, we can manage and maintain through the existing Redshift Data API already set up.

### Other Information

I am currently working on this, and it seems there will be a need to refactor the `UserTablePrivileges` internal construct, which I can create a separate `refactor` PR for.

### Acknowledgements

- [X] I may be able to implement this feature request
- [ ] This feature might incur a breaking change

### CDK version used

2.76.0

### Environment details (OS name and version, etc.)

Amazon Linux 2

Contributor guide

Open the contributing guide

Research direction

Start with the existing Redshift construct and its configured Redshift Data API, then inspect the UserTablePrivileges internal construct mentioned in the issue. The work is complete when the construct exposes an API for creating and maintaining Redshift user groups through the existing Data API, with appropriate tests added.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, typescript
Domain
cloud, databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.