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:
- Click your username at the top right of the AWS console.
- From the dropdown menu, click [Security Credentials].
- Move to the [Access Management > Users] tab from the left navigation.
- Click [Add User].
- Enter a user name of your choice (e.g.,
querier-athena
). - On the [Set Permissions] screen, choose [Attach policies directly].
- Select any permission policy related to Amazon Athena.
- Click [Create User].
- Note the [Access Key ID] and [Secret Access Key].
Connection Method
1. Create a new data source connection
- Click the [Resources] tab.
- Click the [Create] button next to [Resources].
- Select [Amazon Athena].
2. Enter the connection information
Field | Description |
---|---|
Name | Enter the name for the Amazon Athena connection. |
Region | Enter the Amazon Athena region. |
Access Key ID | Enter the Amazon Athena access key ID. |
Secret Access Key | Enter the Amazon Athena secret access key. |
S3 Output Location | Enter in the format s3://bucket-name . |
Workgroup | Enter the Amazon Athena workgroup. |