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 “>”. AWS Docs: connecting to your cluster.
> 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;
Note- 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;
3. Gather your cluster information.
***Your Redshift must be publicly accessible. If not, see note at the bottom of this article
- 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.
4. Log in to Sisu.
5. Click on Data in the upper left-hand corner.
6. Click + New data source.
7. Under Connect New complete all the required fields.
- Host Name (from the AWS endpoint).
- Port (e.g., 5439) into the Port field.
- Database Name (e.g., dev) into the Database Name field.
- Finally, enter the Sisu Redshift user’s username (e.g., sisu) and password.
- Data Source Name will be the name that Sisu shows in the data connection listing.
*Select Restrict Access - if you want to restrict this data source to specific users.
8. Click Add.
***If your Redshift instance is not publicly available, then please contact the Sisu team for other options. We support:
- Hybrid VPC-based deployment
- IP-based restrictions via proxy whitelisting or security group restrictions