Configure Networking and Security Groups

There are two types of Redshift cluster subnets:

  • EC2 Classic subnet
  • VPC subnet

Let’s see what our cluster supports as it depends on the region you are. 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.

Configure Networking and Amazon Redshift Security Groups

You can find more details about these two subnet types you may check from Amazon the Managing Clusters in an Amazon Virtual Private Cloud (VPC) guide.

Configure Security Groups

Amazon Redshift permissions: EC2-Classic

Click on the name next to Cluster Security Groups.

Configure Networking and Amazon Redshift Security Groups - EC2-Classic

Then you will see a new page called Security. Click on the name of your Security group. At next page click on Add Connection Type.

In the pop-up choose Connection Type: CIDR/IP and the default IP is your current IP address.

Configure Networking and Amazon Redshift Security Groups - EC2-Classic

Click Authorize.

Amazon Redshift permissions: EC2-VPC

For our example case, click on the name next to VPC Security Groups.

Configure Networking and Amazon Redshift Security Groups - EC2-VPC

Click the Inbound tab and then click on Edit.

Configure Networking and Amazon Redshift Security Groups - EC2-VPC

We need to add one rule.

In the Type drop-down select Redshift. Then leave the defaults. At Source, in the drop-down select My IP. Leave the default.

Configure Networking and Amazon Redshift Security Groups - EC2-VPC

Click Save

Now we are ready to connect to our cluster. There are various tools to connect to your Amazon Redshift cluster, and we will see them later in more detail. For now, we will try a connection with SQL Workbench/J.

Connecting with SQL Workbench/J

Let’s see how to connect with SQL Workbench/J*.

  1. Download SQL Workbench/J from here.
  2. Read the Installing and starting SQL Workbench/J page from here.
  3. Download the latest Amazon Redshift JDBC drivers from Amazon here.
  4. Open SQL Workbench/J.
  5. If the Select Connection Profile does not open, click File, and then Connect.
  6. Type a name for the profile. For example, The Lannisters.
  7. Click Manage Drivers.
  8. In the new window find and select the JAR with the Amazon Redshift JDBC Driver.
  9. Click OK
  10. For the rest of settings check the screenshot below.

Configure Networking and Amazon Redshift Security Groups - Connecting with SQL Workbench/J

*For more detailed instructions examine the documentation from AWS here.

Click on Test, and if you see the bellow message, you are in.

Configure Networking and Amazon Redshift Security Groups - Connecting with SQL Workbench/J

load data into any data warehouse - Blendo