REDSHIFT DOCUMENTATION DRIVER

Looker uses the JDBC driver to connect to Redshift. 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.Īs an alternative, Tableau can also use the JDBC driver to connect to Redshift which does support the TLS SNI extension. 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. Please use version 2.0.93 or higher of the redshift-connector for python. TLS SNI not supported by redshift-connector Psql -h .p0. -p 12340 -U john example Connecting with the Python Connector In prior versions, PSQL uses the TLS1.0 protocol by default which is considered insecure and is not supported by Satori. Please use version 13.1 or higher of PSQL. Connecting with the PSQL Command Line Utility For example, when connecting to. set ClusterID to abc123 and Region to us-east-2. When using Amazon Identity and Access Management (IAM) to authenticate to Redshift, ensure that the ClusterID and Region properties are set. For Connecting with the JDBC Driver and AWS IAM To connect with the JDBC driver, override or add the host parameter in the JDBC URL. The custom port number can be found in the data store setting in the management console. For clients that do not support the SNI extension, Satori can enable a custom, dedicated port which overcomes the problem. 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. 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: .p0.

You will be redirected to the Data Stores list. Satori will automatically choose the correct region.You can find the hostname of your Redshift cluster in the AWS console. Enter the hostname of your Redshift cluster, for example:.Enter an informative name for the data store, for example: Sales Data Warehouse.In the Data Stores view, select Add Data Store.Login to the atori's management console at.The hostname of your Redshift data store, for example:.It only takes a few minutes to get started with Satori. Adding an AWS Redshift Data Store to SatoriĬonnecting with the JDBC Driver and AWS IAMĬonnecting with the PSQL Command Line Utility

Redshift documentation