Skip to content

AWS Redshift Guide

Screenshot

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 the atori'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.

TLS SNI Required

To connect to Redshift via Satori, the client application needs to support the Server Name Identification (SNI) extension of the Transport Level Security (TLS) protocol. For clients that do not support the SNI extension, Satori can enable a custom, dedicated port which overcomes the problem. The custom port number can be found in the data store setting in the management console.

Please contact Support for more details.

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 the PSQL Command Line Utility

TLS SNI not supported by PSQL Please use version 13.1 or higher of PSQL. In prior versions, PSQL uses the TLS1.0 protocol by default which is considered insecure and is not supported by Satori.

To connect to Redshift using PSQL change the host parameter to the Satori generated hostname and use the custom dedicated port for your data store. For example: psql -h abc123.ci3gimsawmqt.us-east-2.a.p0.satoricyber.net -p 12340 -U john example

Connecting with Tableau

TLS SNI not supported by PSQL

To connect to Redshift using AWS QuickSight override the Server and Port fields in the data source settings with the Satori hostname and custom dedicated port for your data store.

As an alternative, Tableau can also use the JDBC driver to connect to Redshift which does support the TLS SNI extension.

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.

Connecting with AWS QuickSight

TLS SNI not supported by PSQL

To connect to Redshift using AWS QuickSight override the Database server and Port fields in the data source settings with the Satori hostname and custom dedicated port for your data store.