Step 2: Configuring networking and Amazon Redshift permissions

This guide considers that you already have a Redshift cluster setup. If not you can read how to setup an Amazon Redshift instance.

Permissioning Blendo: In order to ensure Blendo will have access to your Amazon Redshift please make sure to white list and allow connection from these IP addresses: 52.18.126.160/32, and 52.213.36.20/32
For more instructions please continue bellow.

Let’s see how to setup Amazon Redshift permissions to allow Blendo to write into your instance. You will need to configure your Redshift cluster to allow Blendo to write into it. There are two types of Redshift clusters subnets:

  • EC2 Classic subnet
  • VPC subnet

You can find more information from Amazon on Managing Clusters in an Amazon Virtual Private Cloud (VPC).

Which you support depends if it is supported by the region you are. In order to see this you will have to check your cluster’s configuration tab. You will either see a field called Cluster Security Groups or VPC Security Groups.

Amazon Redshift permissions

Amazon Redshift permissions: EC2-Classic

1. Go to your Redshift Dashboard, and click on your cluster. We will have to add two (2) rules.

2. Click on the name next to Cluster Security Groups.

Amazon Redshift permissions: EC2-Classic

3. This will get you to a new page called Security. click on the name of your Security group. At next page click on Add Connection Type.

4. In the pop-up choose:

  • Connection Type: CIDR/IP
  • CIDR/IP to Authorize: 52.18.126.160/32

Amazon Redshift permissions: EC2-Classic

5. Click Authorize.

6. Let’s add the rest of the IP addresses. Repeat steps 3-5 for each of the following CIDR/IP:

  • 52.213.36.20/32

Amazon Redshift permissions: EC2-VPC

1. Go to your Redshift Dashboard, and click on your cluster.

2. Click on the name next to VPC Security Groups.

Amazon Redshift permissions: EC2-VPC

3. Click the Inbound tab and then click on Edit.

Amazon Redshift permissions: EC2-VPC

4. We will have to add two (2) rules.

5. In the Type drop-down select Redshift. Then leave the defaults. At Source, in the drop-down select Custom IP. Type 52.18.126.160

Amazon Redshift permissions: EC2-VPC

6. Let’s create rules for the rest of the IPs. Repeat step 5 for each of the following:

  • 52.213.36.20

7. Click Save.

Next Steps:

In the next section we will see how to connect Blendo to Amazon Redshift in order to send your data.

READ NEXT: Step 3: How to connect and setup Amazon Redshift integration

Questions? Contact us!

in Amazon Redshift