Redshift

How to set up the Redshift connection and additional notes on using it

With Codatum, you can connect, query, and manage data of Redshift.

This feature is currently in preview. Functionality and availability may change without notice.

We'd love your feedback.

How to Set Up

Redshift integration targets RA3 node clusters and serverless configurations.

1. Necessary preparations in AWS Console

Grant the Necessary Privileges

Create a role for integration and grant privileges.

• Grant USAGE privilege on the schema you want to use to that role

• Grant SELECT privilege on the tables you want to use to that role

• Grant SELECT privilege on the system view svv_table_info to that role

Create IAM User and Grant Policies

• Create an IAM user for integration and grant the AmazonRedshiftFullAccess policy

Creat Secret in Secrets Manager

• Specify the Data Warehouse you want to connect to and create a Secret

• Add a tag named RedshiftDataFullAccess to the created Secret (Value can be empty)

2. Register Redshift connection in Codatum

Finally, create a Redshift connection in Codatum.

• Select Add Connection from Connections in Workspace Settings

• Enter Connection Name

• Select Access Level

• Enter Account ID

  • This is your AWS account ID.

• Enter Region

  • This is the region where your Redshift resources are located.

• Select Connection Type

  • If you select Cluster:

    • Enter Cluster Identifier

    • Enter Default Database

      • This is the target database for connection. This setting does not restrict queryable databases, schemas, or tables.

  • If you select Serverless:

    • Enter Serverless Namespace

    • Enter Serverless Workgroup Name

    • Enter Default Database

      • This is the target database for connection. This setting does not restrict queryable databases, schemas, or tables.

• Enter AWS Access Key

  • Use the access key of the IAM user prepared in Step 1.

• Enter AWS Secret Access Key

  • Use the secret access key of the IAM user prepared in Step 1.

• Enter Secret ARN

  • Use the Secret ARN of the Secret prepared in Step 1.

Once you have completed the input, perform a connection test and then save the connection.