Redshift
Overview
This doc outlines how to use the Redshift integration to create and manage tables in your Cargo.
Setup
Requirements
- Active Amazon Redshift cluster
- Network connectivity between Cargo and your Redshift cluster (if they exist in separate VPCs)
- Proper IAM permissions and database credentials
Guide
-
Verify Cluster Connectivity
- Ensure your Redshift cluster is active and accessible from Cargo
- Use the "Test Connection" feature in the Cargo UI to verify connectivity
- For network configuration help, refer to the AWS Redshift documentation
-
Configure Connection Details
- Provide the following connection information:
- Host: Your Redshift endpoint (format:
<cluster-id>.<region>.redshift.amazonaws.com) - Port: Default is 5439
- Database name
- Username and password
- Host: Your Redshift endpoint (format:
- All information can be found in your AWS Redshift console under cluster details
- Provide the following connection information:
Allow Cargo IP addresses
If you restrict access to your Redshift cluster, make sure Cargo is allowed to access it by whitelisting our IP addresses:
- 3.251.34.134
- 54.220.135.99
- 79.125.105.52
Security
- All Redshift connections are encrypted using SSL/TLS
- Credentials are securely stored and encrypted at rest