Open Navigation

Redshift

The Redshift connector allows you to query your Redshift database directly within tray.io, without having to worry about data pipelines or servers.
On This Page

Overview

Connecting to your Redshift instance

To allow tray.io to connect to your Redshift database, you'll need to either make your database publicly accessible or you can white list ALL of the following static IP addresses for access:

  • 52.40.200.248
  • 52.39.10.61
  • 52.26.59.155

Note: it is extremely important that your Redshift database is only accessible with a strong username and password combination when white listing these IP addresses, as they will be used by anyone using the connector in a Tray workflow. If you wish to have a more secure connection, please contact Sales about our private static IP or private cluster options.

To do this:

  1. Open up the "Security" section of your Redhift AWS. Open the "default" security group. Default security group
  2. Click "Add Connection Type" Add connection type
  3. Add a new "Connection Type", using the "CIDR/IP" connection type, and one of the above IP addresses as the IP address to authorize. CIDR/IP
Was this article helpful?
Yes
No
On This Page