Redshift Preview

Connect Codatum to Redshift to run SQL and manage data. Supported targets are RA3 node clusters and serverless. For an overview of connections in general, see Connection.

INFO

This feature is in preview. To request access, contact Codatum support.

Preparing AWS

• DB: Grant the integration role USAGE on the schema, SELECT on the tables, and SELECT on svv_table_info.
• IAM: Grant AmazonRedshiftFullAccess to the integration IAM user.
• Secrets Manager: Create a secret for the connection target and add the RedshiftDataFullAccess tag (the value can be empty).

Configuring Codatum

1. Open global nav > Workspace settings > Data management > Connections, then select New connection.
2. Select Amazon Redshift (only shown if it's available to you).
3. Enter a Connection name and select an Access level.
4. Enter the following.

Item	Description
Account ID	Your AWS account ID
Region	The region of your Redshift resources
Connection type	Cluster or Serverless (default is cluster)
Cluster identifier	When the connection type is cluster
Serverless namespace	When the connection type is serverless
Serverless workgroup name	When the connection type is serverless
Default database	The database to connect to (this doesn't limit which SQL you can run)
AWS access key ID	The access key ID of the IAM user
AWS secret access key	The secret access key of the IAM user
Secret ARN	The ARN of the secret in Secrets Manager

After entering these, run Test connect, then save the connection. On the sync targets screen shown after saving, select the databases/schemas to sync (Table metadata sync). You can also skip this step.