Very basic Redshift Serverless deployment

This project will deploy the most basic implementation of Redshift Serverless in a single stack. The stack includes:

• A VPC with private and public subnets
• A Redshift Serverless Namespace
• A publicly accessible Redshift Serverless Workgroup
• A security group to limit access to the Workgroup to whitelisted IPs

Useful commands

• npm run deploy deploys both the Namespace and Workgroups stacks
• npm run destroy destroys both the Namespace and Workgroups stacks
• npm run format make all of the files prettier

How to deploy

• Get the secret access id and secret access key from AWS IAM for a user with the rights to use cloudformation and deploy Redshift, VPCs and Security Groups
  • Add the keys to ~/.aws/credentials
• Create file config.ts, copy contents of config.template.ts and et the values in `config.ts':
  • Your AWS account ID
  • Allowed IP Addresses
• run npm ci - to install the necessary packages
• run npm run deploy - to deploy the stacks to your AWS account

How to connect to Redshift Serverless

You can connect to Redshift:

• Using the Query Editor V2 in the AWS Console in Redshift section.
• Using an appropriate tool with an ODBC or JDBC driver. The connection string you can find in AWS Console, in the Redshift section under the appropriate workspace
  • Note, you will have to change the admin password to something you know.