Sections in this category

Connecting to Amazon Redshift

  • Updated

Sisu allows you to connect to your data in Amazon Redshift.

 

Related Articles:

 

Step 1:  Create Access to your Redshift Cluster

Make sure that your Redshift cluster is running and that an administrator can connect to it in a SQL shell. We denote commands to be run in SQL with a “>”. 

Refer to this document for details: Connecting to an Amazon Redshift cluster using SQL client tools

Step 2:  Create a Role for Sisu

Next, you’ll need to create a role for Sisu within Redshift. Use the information below, and refer to this AWS document for details:  Create User

> CREATE USER sisu WITH PASSWORD ‘insert password here’;

Grant Sisu access to the tables it should analyze. Sisu will have access to tables in the public schema. If there’s another table in a restricted schema, say restricted, then grant sisu privileges to access the table.

> GRANT USAGE ON SCHEMA restricted TO sisu;

> GRANT SELECT ON TABLE restricted.some_table TO sisu;

 

tip_icon_-_small.png

If you have a process that refreshes your tables (like Looker PDTs do), then additional steps may be necessary to configure your connection.

Please contact the Sisu team for assistance at success@sisudata.com 

 

 Ensure Sisu can access your table using a SQL shell.

> SELECT * FROM some_public_table LIMIT 1;

> SELECT * FROM restricted.some_table LIMIT 1;

 

Step 3:  Gather Your Cluster Information

warning_icon.png

Your Redshift must be publicly accessible. If it is not, please contact the Sisu team at success@sisudata.com for other options. We support:

  • Hybrid VPC-based deployment
  • IP-based restrictions via proxy whitelisting or security group restrictions

 

  1. From your AWS console, enter "Redshift"
  2. Click on Clusters on the left hand side.
  3. Click the cluster name to view your cluster information.

At the top of this screen you will notice the endpoint that will look something like this:

cluster.XXXXXXXX.us-west-2.redshift.amazonaws.com:5439  

The characters before the colon is the Host Name you will provide in Sisu.  Everything after the colon is the Port number.

You will use this information in the next step.

 

Step 4:  Add Amazon Redshift Data Source in Sisu

To add Athena as a Data Source in Sisu:

  1. In the main Sisu menu at the top of the screen, click Data sources page, then click "+ New data source".

    Data_tab_-_New_data_source.png

  2. Select “Redshift” from the Select data source dropdown, and fill in the following information as described below.

    Host Name

    (from the AWS endpoint)

    Port

    (e.g., 5439)

    Database Name

    (e.g., dev)

    Username

    The Sisu Redshift user’s username from Step 2 (e.g., sisu)

    Password

    The Sisu Redshift user’s password from Step 2

    Data Source Name

    The name that will display in the list of data sources in Sisu

    Restrict Access

    Check this if you want to restrict this data source to specific users


    Add_Redshift.png 

    tip_icon_-_small.png Check Restrict Access if you want to restrict this data source to specific users.

     

  3. Click Add.

    info_icon.png

    If your Redshift instance is not publicly available, then please contact the Sisu team at support@sisudata.com for other options. We support:

    • Hybrid VPC-based deployment
    • IP-based restrictions via proxy whitelisting or security group restrictions