AWS Athena

1. In Polytomic, go to Connections → Add Connection → AWS Athena.

2. Enter the following information:

• AWS Access ID
• AWS Secret Access Key
• AWS region (e.g. us-west-1)
• AWS S3 output bucket

3. Click Save.

IAM Permissions

Polytomic uses the following IAM Actions when introspecting Athena. Most users will grant these to the catalogs, databases, and tables they wish to use with Polytomic.

• athena:GetNamedQuery
• athena:GetDataCatalog
• athena:GetPreparedStatement
• athena:GetQueryExecution
• athena:GetQueryResults
• athena:GetQueryResultsStream
• athena:GetTableMetadata
• athena:GetWorkGroup
• athena:ListTableMetadata
• athena:ListDataCatalogs
• athena:ListDatabases
• athena:StartQueryExecution
• athena:StopQueryExecution
• glue:GetTables
• glue:GetTable
• glue:CancelStatement
• glue:GetDatabase
• glue:GetDatabases
• glue:SearchTables

If you would like to write to Athena, make sure to add these two permissions as well:

• glue:CreateTable
• glue:UpdateTable