Search documentation...

K

Amazon Redshift

Amazon Redshift is a fully managed, petabyte-scale data warehouse service in the cloud. It is built on Amazon Web Services

Create the Warehouse connection in Hightouch

You'll need to allowlist Hightouch's IP addresses to allow our systems to contact your warehouse. Reference our docs to determine which IPs you need to allowlist.

  1. In Hightouch, go to Sources or click https://app.hightouch.com/sources
    Selecting Add Source
  2. Click "Create Source"
    Selecting Postgres 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.
Both of these options are now self-serve and can be referenced here.

    Need help?

    Our team is relentlessly focused on your success. We're ready to jump on a call to help unblock you.

    • Connection issues with your data warehouse?
    • Confusing API responses from destination systems?
    • Unsupported destination objects or modes?
    • Help with complex SQL queries?

    or

    Feature Requests?

    If you see something that's missing from our app, let us know and we'll work with you to build it!

    We want to hear your suggestions for new sources, destinations, and other features that would help you activate your data.

On this page

Create the Warehouse connection in Hightouch

Was this page helpful?