To allow Causal to connect to your Redshift database, you'll need to action the following items: 1. Make your database publicly accessible
2. White list Causal IP addresses

Make your database publicly accessible

To do this:
1. Go to the Properties of your Redshift cluster.
2. Verify the setting, correct setting is Enabled, if not, hit Edit
3. Enable the setting and hit Save changes, allow for up to 10 minutes for the changes to take effect.

White list ALL of the following static IP addresses for access:

Note: be sure to make it so that your Redshift database is only accessible with a strong username and password combination when white listing these IP addresses.
To do this:
1. Go to the properties of your Redshift cluster and click on the VPC security group.
2. Click the Inbound rules-tab and then Edit inbound rules.
3. Select the Redshift type, add your external IP address in CIDR block format and click Save rules.

Data Connection Form

Complete the data connection form above with the following details:
Endpoint Hostname
In order to get details about your Redshift cluster, log on to AWS and head over to the Clusters screen in your Amazon Redshift account. From the available list of clusters, select the one that you're trying to connect.
Copy the cluster endpoint URL. It should have the following format:
Enter the {hostname} part into the Cluster endpoint hostname field
Database Name and Port
To get the 'Port' and 'Database' fields, head to your AWS account. On the same page from which you just copied your Endpoint URL, select the 'Properties' tab. This should be below the 'General information' section.
Scroll down to the 'Database configurations' area. Here, you will find your cluster's 'Database name' and 'Port'. Copy and paste this information into form fields.
User and Password
PLEASE NOTE: These user credentials are specific to the Redshift cluster and not AWS services.
In this example the primary user's credentials are displayed. Aka, the credentials that were created when first configuring the cluster.
If you want to use other individual's credentials for authentication, use the following query select * from pg_user; to retrieve their user details.
Remember that users will need certain access rights in order to query & manipulate the database.


Once authenticated you will be brought to a configuration form like this:
To configure your Redshift data source you will need to specify the query, the date column, and any variable columns. The date column should be one of Redshift's date formats and variable columns should be numeric.
Any columns that aren't a date or variable column will be considered a category, and should have a string type. An exception is the 'cohort' category, which should be a date, with the column header explicitly labelled Cohort.
Last modified 5mo ago