Documentation

Redshift

IMPORTANT: This article covers setup of warehouse for load data from Improvado, not customer data warehouse from which data is being extracted. This article doesn't cover setup of customer data warehouse for Data Prep as well.

Required information

  • Title
  • Host
  • ~Host name must satisfy the following regular expression: r'^(?<cluster>[a-zA-Z][a-zA-Z0-9\-]{1,30}[^\-])\.'r'(?<id>[a-zA-Z0-9]+)\.'r'(?<region>[a-z0-9\-]+)\.'r'redshift\.amazonaws\.com$'
  • Port
  • User Name
  • Password
  • Database Name
  • Schema
  • ~Specify the schema of your database

Host naming rules

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

  • Cluster part must contain 1-30 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
  • Region part must be a valid AWS region (also check supported regions section).

Make sure your value for Host field matches following regular expression:

^(?P[a-zA-Z][a-zA-Z0-9\-]{1,30}[^\-])\.(?P[a-zA-Z0-9]+)\.(?P[a-z0-9\-]+)\.redshift\.amazonaws\.com$

For more information, see AWS documentation.

IMPORTANT:

Invalid host name examples:

  • examplecluster.abc12q0z@c34.us-east-1.redshift.amazonaws.com
  • 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 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

Encryption

Improvado uses SSL connection to encrypt data passed to your Redshift cluster. Connection is established in verify-full mode. Improvado supports SSL certificates provided by ACM by default.

IMPORTANT: by default, cluster databases accept a connection whether it uses SSL or not. To configure your cluster to require an SSL connection, set the require_SSL parameter to true in the parameter group that is associated with the cluster.

For more information, see AWS documentation.

How to connect

You should whitelist following IP addresses of our servers:

  • 34.226.37.150
  • 18.213.72.135
  • 54.146.15.122
  • 3.86.170.178
  • 23.21.191.65

You should have the following permissions for the database:

  • CREATE
  • SELECT
  • INSERT
  • DELETE
Related articles
No items found.
No items found.