Create a connection - Amazon Redshift

You can configure Optimizely Analytics over data stored in a Redshift warehouse. The following quick links are the various procedures you must perform during the configuration:

• Configure your Redshift Connection.
• Edit your Redshift Connection.
• Delete or duplicate your Redshift Connection.

Use the following steps to connect your data in Redshift:

1. Configure a Redshift user with a unique username and password.

2. Provide the Redshift user with read permissions for the specific table, views, or schemas you want 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 five minutes:

   • Go to the workgroup configuration.

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

IP allowlisting

You must add IPs to the allowlist if a security group (firewall) guards your Redshift cluster and prevents access from Analytics.

Add the following IPs to the allowlist for Analytics to access Redshift:

• 3.215.188.76
• 3.217.27.33
• 3.233.246.20
• 54.164.43.201