Skip to main content

Connect to Amazon Athena

You can connect to Athena and make it available as a resource in Retool. Once complete, your users can write queries that interact with Athena data.


All users for Retool organizations on Free or Team plans have global Edit permissions and can add, edit, and remove resources. If your organization manages user permissions for resources, you must be a member of a group with Edit all permissions.

To create a Athena resource, you need authentication credentials for the AWS IAM user associated with your Athena service.

1. Create a new resource

Sign in to your Retool organization and navigate to the Resources tab. Click Create new, then select Resource.

Create a new resource

2. Select the resource type

Retool can connect to almost any API or database, and has built-in integrations for popular data sources. Select the Amazon Athena resource type.

Select Athena resource

3. Configure the resource

Specify a name and location for the Athena resource. Retool displays the resource name and type in query editors to help users identify them. Next, configure the required settings.


AWS RegionThe AWS region of your service.
S3 Output LocationThe location to store query results.


AWS Access Key IDThe access key for the IAM user.
AWS Secret Key IDThe secret key for the IAM user.
Role to assume (ARN)The role for the IAM user to assume.

Configure Amazon Athena settings page

Click Test Connection to verify that Retool can connect to Athena. If the test fails, check the resource settings and try again. Testing a connection only checks whether Retool can successfully connect to the resource. It cannot check whether the provided credentials have sufficient privileges or can perform every supported action.

4. Save the resource

Click Create resource to complete the setup. You can then click either Create app to immediately start building a Retool app or Back to resources to return to the list of resources.

Resource created with Athena data

Wrap up

Your Athena resource is now ready to use. To interact with Athena data, select the resource in the query editor. You can read data using SQL queries, write data using GUI queries (if enabled), and use the schema browser to search tables or columns.