Redshift Setup

In order to setup a Redshift integration, you will need to allow-list an IP address. In the initial sync, table(s) will be created in the specified schema.

 

If you are a Civis user, contact support@civisanalytics.com with your static IP. Support at Civis will need to take the following steps to enable your setup of a sync. 

  1. Allow-list the IP address provided to you by Bluelink in your Redshift cluster. 
  2. Create a Redshift user with permissions to read, write, and create tables in the destination schema. 
    1. For tighter security, you can use a specific schema for this data and only give permissions to that schema. If you do, make sure to send the schema name along with permissions. 
  3. Use a OneTimeSecret to securely share the username, password, and cluster connection string (JDBC URL) with Bluelink. 
    1. By default the data will be written to the public schema. If you would like the table to be created somewhere else, provide the destination schema to Bluelink.