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. You'll also need to whitelist the Retool IP address:
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".
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 10 months ago