Documentation

Note: Redshift is currently supported only as a Destination. This guide doesn’t cover the DataPrep setup for Redshift.

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:

1. Enter a name for your Destination connection in the Title.
2. Enter the Host.
3. Enter the Port.
4. Enter the User Name.
5. Enter the Password.
6. Enter the Database Name.
7. Enter the Schema.
8. Select the necessary Use binary strings option from the dropdown. {%dropdown-button name="use-binary-strings"%}

{%dropdown-body name="use-binary-strings"%}

The "Use binary strings" determines whether string fields are encoded in binary format when loading data.

Recommended setting: "No" (default).

{%dropdown-end%}

‍

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.

{%docs-informer info title="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```

{%docs-informer-end%}

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.