Documentation

Redshift

Updated on

Jun 24, 2024

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.

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.

Schema information

Setup guide

Settings

No items found.

Troubleshooting

Troubleshooting guides

Check out troubleshooting guides for
Redshift
here:

Limits

Frequently asked questions

No items found.
☶ On this page
Description
Related articles
No items found.
No items found.

Questions?

Improvado team is always happy to help with any other questions you might have! Send us an email.

Contact your Customer Success Manager or raise a request in Improvado Service Desk.