Documentation
Data sources
Connect Databses
Amazon Athena

Amazon Athena

With Querier, you can integrate with Amazon Athena to execute various queries.

Preparation

Follow these steps to obtain the connection information for Amazon Athena:

  1. Click your username at the top right of the AWS console.
  2. From the dropdown menu, click [Security Credentials].
  3. Move to the [Access Management > Users] tab from the left navigation.
  4. Click [Add User].
  5. Enter a user name of your choice (e.g., querier-athena).
  6. On the [Set Permissions] screen, choose [Attach policies directly].
  7. Select any permission policy related to Amazon Athena.
  8. Click [Create User].
  9. Note the [Access Key ID] and [Secret Access Key].

Connection Method

1. Create a new data source connection

  1. Click the [Resources] tab.
  2. Click the [Create] button next to [Resources].
  3. Select [Amazon Athena].

2. Enter the connection information

FieldDescription
NameEnter the name for the Amazon Athena connection.
RegionEnter the Amazon Athena region.
Access Key IDEnter the Amazon Athena access key ID.
Secret Access KeyEnter the Amazon Athena secret access key.
S3 Output LocationEnter in the format s3://bucket-name.
WorkgroupEnter the Amazon Athena workgroup.