Before you can connect to Amazon Redshift, you must complete the following within your Redshift environment: 

# Step 1 - Add Permutive IP addresses to allowlist

Create a rule in a security group that allows Permutive access to your Redshift instance and port. Configure your firewall and/or other access control systems to allow incoming connections to your host and port from Permutive's IPs for your region.

35.234.176.144

35.234.176.145

35.234.176.146

35.234.176.147

35.234.176.148

35.234.176.149

35.234.176.150

35.234.176.151

# Step 2 - Create a Redshift user and grant permissions

We will need a new user to connect to your Redshift cluster. Please ensure the created user has read access permissions to the following tables;

PG_CLASS

PG_NAMESPACE

PG_DATABASE

PG_CONSTRAINT

SVV_ALL_COLUMNS

Once these steps are complete, proceed with connecting from within Permutive...

To connect to Amazon Redshift, navigate to the Connectivity Catalog, search for Amazon Redshift, and click “Connect” on its card.

The “Connect to Amazon Redshift” page contains six required fields:

Name: Provide a name for the connection. This name does not come from Redshift, it is authored by you to be your reference for the connection within Permutive moving forward

Database: Database name, as declared within Redshift

Host: Host name, as declared within Redshift

Port: Port name, as declared within Redshift. Permutive populates this field with 5439 (Redshift default port), but you may override that default depending on your configuration

User: Your Redshift username

Password: Your Redshift password