Depending on your Amazon settings, you may need to grant Mode access to your Redshift security group:

  1. Navigate to the Redshift Management Console.

  2. Select Clusters from the left navigation bar.

  3. Click on the cluster you want to connect.

    Redshift

  4. Find Cluster Security Groups under Cluster Properties and click on the cluster’s security group.

    Redshift

    Note: If you are using VPC Security Groups, you must also grant Mode access to that security group. Please click on your VPC Security Group name and follow this section of our Amazon RDS guide, starting with step 2.

  5. Click on the name of the security group.

    Redshift

  6. You’ll see a list of authorized connections. Click the blue “Add Connection Type” button in the upper left.

  7. Select “CIDR/IP” from the “Connection Type” dropdown, and paste the address 54.68.30.98/32 in the “CIDR/IP to Authorize” field.

    Redshift

  8. Click the blue “Authorize” button

  9. Repeat steps 5 through 7 for each of the addresses listed below:

    • 54.68.30.98/32
    • 54.68.45.3/32
    • 54.164.204.122/32
    • 54.172.100.146/32

Last updated August 21, 2020