RedshiftThe Redshift connector allows you to query your Redshift database directly within tray.io, without having to worry about data pipelines or servers.
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:
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:
- Open up the "Security" section of your Redhift AWS. Open the "default" security group.
- Click "Add Connection Type"
- Add a new "Connection Type", using the "CIDR/IP" connection type, and one of the above IP addresses as the IP address to authorize.