Set up a connection to Amazon Redshift

Naga Sri Hari Gonaboyina

Updated August 10, 2026 11:46

Amazon Redshift is a data warehouse product that helps customers to handle large-scale data storage and database migrations.

Two connectors are available for Amazon Redshift:

Databases: Amazon Redshift – Use this connector to extract, load, and transform (ELT) workflows and other data warehouse automation needs, such as sending or retrieving data.
Connectors: Amazon Redshift (REST API) – Review the Using the Amazon Redshift Data API documentation for your use case, and configure this connector as required.

Set up a database connection to Amazon Redshift

Amazon Redshift documentation: API guide , Authentication

A. Set up an Amazon Redshift connection

Start establishing a connection to Amazon Redshift in either of the following ways:

From the Resources menu, select Connections. Then, click + Create connection at the top right.

– or –
While working in a new or existing integration, you can add an application to a flow simply by clicking Add source or Add destination.

In the resulting Application list, select Amazon Redshift.

The Create connection panel opens with required and advanced settings.

B. Provide required Amazon Redshift application details

At this point, you’re presented with options for providing Amazon Redshift authentication.

Setting	Instructions
Name your connection *	Enter a clear and distinguishable name. Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.
Auth type *	Select IAM role to create an AWS iClient or select Username and Password. Celigo recommends using an IAM role instead of a Username and Password. Creating an AWS iClient with an IAM role lets Celigo securely store and use IAM role details to access supported AWS services.
IAM role
AWS iClient *	Select an existing AWS iClient or create a new one. Creating a new AWS iClient requires some configuration in your AWS Console.
Region *	Select the region for this Redshift account. By default, [us-east-1] is selected.
Default database name *	Enter the Amazon Redshift database name as configured by the administrator.
Default cluster name *	Enter your Amazon Redshift cluster name.
Username and Password
Region *	Select the region for this Redshift account. By default, [us-east-1] is selected.
Access key ID *	Enter the Access key ID you generated in your Amazon Redshift account.
Secret access key *	Enter the secret access key associated with the Access key ID. Multiple layers of protection are in place, including AES 256 encryption, to keep your connection’s Secret access key safe.
Username *	Enter the Amazon Redshift database username. For information on how to create a database user, see Configuring connections in Amazon Redshift.
Default database name *	Enter the Amazon Redshift database name as configured by the administrator.
Default cluster name *	Enter your Amazon Redshift cluster name.

Retrieve your Amazon Redshift Region, Access key ID, and Secret access key

Sign in to your account at aws.amazon.com/console.
You can see the region at the top right. For example, if it says Mumbai, enter ap-south-1 for the Region setting in the connection.
From the Services menu, navigate to Security, identity, & compliance > Identity and access management (IAM).
Under Access management, select Users.
Select the required user and on the user's Summary page, click Security credentials.
If you have an existing Access key ID, you may provide it above, assuming that you already recorded the secret access key. To generate a new access key, click Create access key.
Copy this app's Access key ID and Secret access key.

C. Edit advanced Amazon Redshift settings

sidebar. Optional concurrency and rate limit settings

Borrow concurrency from (optional): Select another connection from the list. By default, all data flowing through a connection record is submitted to the respective endpoint application at the concurrency level configured for that connection record. There are cases, however, where multiple integrator.io connections need to share the same concurrency level, and this field allows you to specify which connection you would like to borrow from. With borrowed concurrency, the data flowing through both connections will be submitted to the endpoint application together, via a shared concurrency model.
Auto-recover rate limit errors: This setting is enabled by default with a predefined value for Target concurrency level. You can disable the setting if required. To set or make changes in any of these settings, you must have admin or manage permissions.
- Target concurrency level: This field is shown only if Auto-recover rate limit errors is enabled. Change the predefined value as required to limit the number of concurrent API requests allowed by the connection resource. See also, Setting currency level on a connection.
- Concurrency level: When Auto-recover rate limit errors is checked, you can't modify the concurrency level because it matches the value set by the connected platform's runtime. When Auto-recover rate limit errors is not checked, you can enter a value to limit the number of concurrent API requests allowed by the connection resource. See also, Setting currency level on a connection.

D. Test the connection

Once you have configured the Amazon Redshift connection, you have a few options for continuing:

Save – click this button to test the connection, commit the new connection so that it will be available to all integrations for your account
Save & close – click to test and save the connection and exit the Create connection panel
Close – click to exit without saving any new changes
Test connection – click this button to verify that your new connection is free of errors

The new connection is now successfully added to your account. It will be applied to the current source or destination app if you created it within a flow. Otherwise, you may proceed to register the connection with an integration.