aws-redshiftserverless: Add Max RPU Support

[IkeNefcy]

Describe the feature

Opening this early. Related: aws-cloudformation/cloudformation-coverage-roadmap#1844
Feature likely doesn't already exist due to no CFN support. If anyone wants to help make it a priority for CFN team that would be helpful. (add 👍 to issue above)

Use Case

Despite there being no support, the CDK deployment still overwrites any manually added max RPU value, which makes this a vital feature for CI/CD.

Proposed Solution

Once this issue is resolved aws-cloudformation/cloudformation-coverage-roadmap#1844,
please add Max RPU support in CDK.

Other Information

No response

Acknowledgements

• I may be able to implement this feature request
• This feature might incur a breaking change

CDK version used

2.128.0

Environment details (OS name and version, etc.)

MacBook Pro M2

[IkeNefcy]

Looks like there is no aws-redshiftserverless tag. Bot is confused.

[tim-finnigan]

Thanks for the feature request. I'll add the appropriate labels here. Others can add a 👍 to aws-cloudformation/cloudformation-coverage-roadmap#1844 to help with visibility.

[IkeNefcy]

@tim-finnigan Hey, the issue I mentioned for CFN has been updated. The Max Capacity option has been added. I ran a test with my gamma env and it worked just fine editing the redshift serverless wg capacity.
Syntax added here https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-redshiftserverless-workgroup.html.
Updating so you know that this CDK ticket is viable to be worked whenever the team gets a chance (might even already be in from what I'm seeing). Thanks again.

[IkeNefcy]

The Max capacity has been updated in the docs here https://docs.aws.amazon.com/cdk/api/v2/docs/aws-cdk-lib.aws_redshiftserverless.CfnWorkgroup.html
But when inspecting the interface CfnWorkgroupProps{} it looks like this isn't actually added yet.
Looks like this is due to the construct being L1.

[github-actions]

⚠️COMMENT VISIBILITY WARNING⚠️

Comments on closed issues are hard for our team to see.
If you need more assistance, please either tag a team member or open a new issue that references this one.
If you wish to keep having a conversation with other community members under this issue feel free to do so.