Skip to content

AWS Redshift Guide

It only takes a few minutes to get started with Satori. What you need is:

  • Access to Satori's management console.
  • The hostname of your Redshift data store, for example: abc123.ci3gimsawmqt.us-east-2.redshift.amazonaws.com.

Adding an AWS Redshift data store to Satori

  1. Login to Satori's management console at https://app.satoricyber.com.
  2. In the Data Stores view, select Add Data Store.
  3. Select the Redshift option.
  4. Enter an informative name for the data store, for example: Sales Data Warehouse.
  5. Enter the hostname of your Redshift cluster, for example: abc123.ci3gimsawmqt.us-east-2.redshift.amazonaws.com. You can find the hostname of your Redshift cluster in the AWS console.
  6. Satori will automatically choose the correct region.
  7. Click Create. You will be redirected to the Data Stores list.

Connect to AWS Redshift via Satori

To connect to Redshift using Satori use the Satori hostname that was generated by the management console which can be found under Satori Hostname in the data store settings view, for example: abc123.ci3gimsawmqt.us-east-2.a.p0.satoricyber.net.

Connecting with the JDBC driver

To connect with the JDBC driver, override or add the host parameter in the JDBC URL. For example:

jdbc:redshift://abc123.ci3gimsawmqt.us-east-2.a.p0.satoricyber.net/?user=john@example.com&...

Connecting with Tableau

The native AWS Redshift connection in Tableau uses the AWS Redshift ODBC driver which does not support the TLS Server Name Identification (SNI) extension needed by Satori in order to proxy the connection from Tableau to Redshift. To overcome this, please create a new Other Databases (JDBC) connection (follow the instructions here) and in the JDBC URL value, replace the original .amazonaws.com value to the .satoricyber.net value generated for the Redshift data store in the Satori management console.

Connecting with Looker

Looker uses the JDBC driver to connect to Redshift. Override the Remote Host:Port parameter with the Satori hostname. For example: abc123.ci3gimsawmqt.us-east-2.a.p0.satoricyber.net:5439.