[redshift] Cannot create more than 1 redshift cluster due to hard-coded security group name

[mitchlloyd]

Cannot create more than 1 Redshift Cluster in an account because the redshift security group "redshift SG" name must be unique.

Reproduction Steps

import * as ec2 from '@aws-cdk/aws-ec2';
import * as redshift from '@aws-cdk/aws-redshift';
import * as cdk from '@aws-cdk/core';

export class RedshiftStack extends cdk.Stack {
  constructor(scope: cdk.Construct, id: string, props?: cdk.StackProps) {
    super(scope, id, props);

    const vpc = new ec2.Vpc(this, 'VPC');

    new redshift.Cluster(this, 'R1', {
      vpc,
      masterUser: {
        masterUsername: 'name',
      },
    });

    new redshift.Cluster(this, 'R2', {
      vpc,
      masterUser: {
        masterUsername: 'name',
      },
    });
  }
}

What did you expect to happen?

Create 2 redshift clusters.

What actually happened?

Cloudformation error:

redshift SG already exists in stack arn:aws:cloudformation:us-west-2...

Environment

• CLI Version : 1.66.0
• Framework Version: 1.66.0
• Node.js Version: v12.18.4
• OS : MacOS
• Language (Version): TypeScript 4.0.2

Other

Hard coded security group name:

aws-cdk/packages/@aws-cdk/aws-redshift/lib/cluster.ts

Line 419 in a76428b

securityGroupName: 'redshift SG',

Security group names must be unique:
https://docs.aws.amazon.com/vpc/latest/userguide/VPC_SecurityGroups.html

---

This is 🐛 Bug Report

[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.