Amazon Redshift

Configuration details for the Amazon Redshift connection

This guide will explain how to connect your Amazon Redshift cluster to Hightouch.

Networking

Hightouch will always connect to your warehouse from 54.196.30.169 or 52.72.201.213. You may allow this IP address in your VPC security groups.

Create the Warehouse connection in Hightouch

1. In Hightouch, go to Sources or click https://app.hightouch.io/sources‚Äč

2. Click "Create Source"

3. Select Redshift

4. Enter your hostname (IP address or EC2 hostname)

5. For Port, enter your port. This is 5432 by default.

6. For User, enter your Redshift (Postgres) username.

7. For Password, enter your Redshift (Postgres) password

8. Click "Test" to test the connection. Hightouch is able to successfully connect, click the "Complete" button at the bottom of the page

--

If your Amazon Redshift cluster is not "publicly accessible", you have two options

  • SSH tunnel: Hightouch will connect to your Amazon Redshift cluster via an SSH tunnel established from Hightouch's servers to a bastion server in your VPC.

  • Reverse SSH tunnel: You will establish an SSH connection from a bastion server in your VPC to Hightouch's servers, and Hightouch will reuse that connection to connect to Redshift.

For either option, please email [email protected] or book a meeting on our calendar to get setup.