Sisu allows you to connect to your data in Amazon Redshift.
Related Articles:
- Understanding Data & Data Sources in Sisu
- Allowlisting Sisu Static IPs for Data Sources
- Adding & Removing a Restricted Data Source
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; |
 |
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
 |
Your Redshift must be publicly accessible. If it is not, please contact the Sisu team at success@sisudata.com for other options. We support:
|
- From your AWS console, enter "Redshift"
- Click on Clusters on the left hand side.
- 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:
- In the main Sisu menu at the top of the screen, click Data sources page, then click "+ New data source".
- 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
Check Restrict Access if you want to restrict this data source to specific users. - Click Add.
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