Athena lets you use SQL to query arbitrary data stored in S3.

1. Get Redshift Details & Whitelist Retool IP Address

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: 52.175.251.223.

AWS Console > Redshift > Clusters

2. Add to Retool

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".

Resources > Add > Amazon Redshift

3. Create Queries

You can now select your newly-created Redshift resource from the Resource dropdown when creating queries in your Retool apps.

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