How to Grant Access to SnapLogic's IPs for Amazon Redshift

In order for SnapLogic’s Snaplex application to be able to read and write data to your Amazon Redshift cluster, we need allow external connection from the SnapLogic IP addresses for inbound access.

  1. Open the Clusters page within the Amazon Redshift console and choose the cluster you wish to integrate with.
  2. Click the “Properties” tab:

  1. In the “Network and security” section, click the “Edit publicly accessible” button and change it to be “Enabled” (if not already).

image

  1. Click the link to the security group for the cluster:

image

  1. Under the “Inbound rules” tab, click the “Edit inbound rules” button and add the following entries, clicking the “Add Rule” button after each one (you may customize the Description column value as you see fit):

Redshift TCP 5439 52.11.8.103/32
Redshift TCP 5439 34.208.181.167/32
Redshift TCP 5439 52.10.35.99/32
Redshift TCP 5439 52.36.97.11/32
Redshift TCP 5439 34.208.230.181/32
Redshift TCP 5439 34.209.24.34/32

  1. SnapLogic should now be able to connect to your Redshift cluster directly. If you experience any issues, follow the Amazon Redshift documentation for assistance, or please do contact us at trial-support@snaplogic.com.