Redshift Integration

Connecting Redshift to Retool

You can connect Redshift as a data source and make it available to your Retool apps.

1. Obtain Redshift details

You can find your Redshift cluster details via the AWS console. The Endpoint section gives you the hostname and port all in one. You'll need to get the database name and a username/password from whoever set up the Redshift cluster.

Retool requires access to the PUBLIC schema to:

  • Ensure that the functionality of the query editor matches the permissions of the database.
  • Populate the schema browser in the query editor.

2. Allow access to Redshift

Retool must be able to connect to your Redshift data source. Ensure that you include Retool's IP addresses to your allowlist so your Redshift data is available to query.

3. Create a Redshift resource

Create a new resource in Retool, and select "Amazon Redshift" as the type.

Enter your cluster's hostname and port, the database's name, and a username/password combination and press "Save".

4. Create queries

You can now select your newly-created Redshift resource from the Resource dropdown when creating queries in your Retool apps. You can toggle between SQL mode for raw SQL statements or the GUI mode for structured writes.

You can display the results of Redshift queries as with any other query in Retool: