Amazon Redshift Serverless connection
Amazon Redshift Serverless is a fully managed, on-demand data warehouse that automatically provisions and scales resources to match query performance.
Prerequisites
To use Amazon Redshift Serverless with the Data Productivity Cloud, ensure you have the following prerequisites in place:
- A working Amazon Redshift Serverless instance set up in your AWS account.
- The Amazon Redshift instance must be accessible—either publicly or within your VPC, depending on your network setup.
- You need Amazon Redshift connection details: endpoint, port (default: 5439), username, and password.
- An S3 bucket must be available and configured for use as a staging location.
- AWS credentials (access key ID and secret access key) must have permissions to read and write to the staging bucket.
Connect to Amazon Redshift Serverless
To connect the Data Productivity Cloud to Amazon Redshift Serverless, follow these steps:
- Log in to your Data Productivity Cloud account.
- In the left navigation, click the Projects icon
.
- Click Add project and follow the guidance in Projects and then Environments to complete the setup.
Once you've completed the environment and credentials setup, your Amazon Redshift Serverless project will appear in the Designer dashboard under the specified project name, and you are ready to start building data pipelines using your Amazon Redshift Serverless environment.