Create a Connection - Amazon Redshift

  • Updated

This guide describes the process of setting up Analytics over data stored in a Redshift warehouse. Following are some quick links to the different procedures that you will need to perform during the setup.

Prerequisites

Following are the steps you need to perform to connect your data in Redshift.

  1. Set up a Redshift user with a unique username and password.

  2. Provide the Redshift user with read permissions for the specific tables, views, or schemas you wish to analyze with Analytics.

  3. Enable case-sensitive lookup for databases, tables, and column names:

    ALTER USER <username> SET enable_case_sensitive_identifier = true

  4. Update the maximum query execution time to 5 minutes:

    • Navigate workgroup configuration.
    • Select Limits tab, and update the limit for “Maximum query execution time” from 14400s to 300s.

IP Whitelisting​

You also need to perform IP Whitelisting - following is the list of IPs that need to be whitelisted for Analytics to access Redshift.

  • 3.215.188.76
  • 3.217.27.33
  • 3.233.246.20
  • 54.164.43.201

Whitelisting IPs is not a mandatory step. It is required only if the Redshift cluster is guarded by a security group (a firewall) that is preventing access to the cluster from Analytics.