Redshift Setup Guide

You can connect Redshift to enable Aleph to query its data directly. To do so, we need a Redshift user that Aleph will use to read the tables and data.

We suggest you create a separate database user for Aleph, with only access to the tables you need to consume in Aleph. If you already have a database user for the finance team, we recommend assigning that user and the Aleph user the same role, so that any table that is made available to the finance user is also available in Aleph.

The steps are:

1. Find your cluster connection string

   1. Sign in to the AWS Management Console and open the Amazon Redshift console

   2. On the navigation menu, choose "Clusters", then choose the cluster name from the list to open its details.

   3. The JDBC URL and ODBC URL connection strings are available, along with additional details, in the "General information" section. Each string is based on the AWS Region where the cluster runs. Click the icon next to the appropriate connection string to copy it.

2. Create a database user with read-only access to the tables you want to access from Aleph

3. If you have an IP whitelist, you must add our server IP 35.202.250.148 to the whitelist

4. Share with us the following information:

   • Cluster connection string

   • Database name

   • Username

   • Password

To share this information securely, you can use Doppler Share or your preferred alternative. For security reasons, we recommend choosing an appropriate expiration time for the share link.

Important: the credential information is sensitive so only share it with authorized individuals.