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:
Updated 4 months ago