This document will help you connect your Redshift data warehouse to Zenlytic to access modern, LLM-powered business intelligence.

First, you'll name your connection. This name is how Zenlytic's model connects the credentials you'll enter in the next step to your data warehouse. You can name the credential whatever you want, but we usually recommend naming it something like my_company_name to keep things simple.

The host for Redshift is the "Endpoint" value in your AWS console.

In this example using Redshift Serverless, the host (privacy obscured) is default.123456789.us-east-1.redshift-serverless.amazonaws.com:5439/dev

This is the username for Redshift. You'll create this user using SQL. In this example, let's assume your username is redshift_user

This is the password associated with the user you entered above.

This is the default database to connect to when connecting to Redshift. You can find this value under Namespace Configuration.

In this example, the database is dev

The default port is 5439, so leave this field empty unless you've changed the value for the port.

This is the schema you want to use as a default. This field is optional and is usually left blank.

If you use IP whitelisting in your data warehouse, whitelist the following IP addresses: