Redshift Destination

Updated on Jun 2, 2025

Note: This article covers Redshift Destination setup process. This guide doesn’t cover the DataPrep setup for Redshift.

You can learn how to extract data from Redshift Data source here.

Description

‍Amazon Redshift is a data warehouse product that forms part of the larger cloud-computing platform Amazon Web Services.

Setup guide

Follow our setup guide to connect Redshift to Improvado.

Whitelist Improvado IPs

You need to whitelist Improvado IPs mentioned on the Destination connection page since Redshift always operates on a range of static IPs.

Permissions

You should have the following permissions for the database:

CREATE
SELECT
INSERT
DELETE

Complete configuration

On the Redshift connection page, fill in the following fields:

Enter a name for your Destination connection in the Title.
Enter the Host.
Enter the Port.
Enter the User Name.
Enter the Password.
Enter the Database Name.
Enter the Schema.
Select the necessary Use binary strings option from the dropdown.

‍

Additional information

Host naming rules

Make sure your value for the Host field matches the following regular expression: ^(?P<cluster>[a-zA-Z][a-zA-Z0-9\-]{1,60}[^\-])\.(?P<id>[a-zA-Z0-9]+)\.(?P<region>[a-z0-9\-]+)\.redshift\.amazonaws\.com$

‍Due to security concerns, Host name is validated according to AWS naming rules:

The cluster part must contain 1-60 characters. Valid characters are A-Z, a-z, 0-9, and hyphen(-). The first character must be a letter. The name can't contain two consecutive hyphens or end with a hyphen.
id part valid characters are only A-Z, a-z, 0-9.
The region part must be a valid AWS region (also check the supported regions section).

For more information, see AWS documentation.

Important

Invalid host name examples:

examplecluster.abc12q0z@c34.us-east-1.redshift.amazonaws.com
https://examplecluster.abc12q0zxc34.us-east-1.redshift.otherdomain.com
example&cluster-.abc12q0zxc34.us-east-1.redshift.amazonaws.com
1example-cluster.abc12q0zxc34.us-east-10.redshift.amazonaws.com

Valid host name example:

example-cluster.abc12q0zxc34.us-east-1.redshift.amazonaws.com

Supported regions

‍Improvado supports data load to Redshift clusters located in the following regions:

us-east-1
us-east-2
us-west-1
us-west-2
eu-north-1
eu-west-1
eu-west-2
eu-west-3
eu-central-1
ap-northeast-1
ap-northeast-2
ap-northeast-3
ap-south-1
ap-southeast-1
ap-southeast-2
ca-central-1
sa-east-1

Load limits

You can load no more than 1599 columns per single load order.