Amazon Redshift
Connect DataDrop to your Redshift data warehouse.
Prerequisites
- A Redshift cluster or Redshift Serverless endpoint
- A database user with read access to the tables you want to export
- An IAM role associated with the cluster that allows UNLOAD to S3
- Network access from DataDrop to your Redshift cluster (VPC peering or public endpoint)
Connection Parameters
| Parameter | Required | Description |
|---|---|---|
| host | Required | Redshift cluster endpoint.e.g. my-cluster.us-east-1.redshift.amazonaws.com |
| port | Optional | Connection port. Defaults to 5439.e.g. 5439 |
| dbname | Required | Database name to connect to.e.g. prod |
| user | Required | Database username.e.g. svc_delivery |
| password | Optional | Database password. Either this or a Secret ARN is required. |
| password_secret | Optional | AWS Secrets Manager ARN storing the password. |
| iam_role | Required | IAM role ARN that Redshift assumes for UNLOAD to S3.e.g. arn:aws:iam::123456789:role/RedshiftS3Role |
IAM Role for UNLOAD
Redshift uses the UNLOAD command to export query results directly to S3. This requires an IAM role attached to the Redshift cluster with permissions to write to your delivery S3 bucket.
The role must have s3:PutObject and s3:GetBucketLocation permissions on the target bucket.