Amazon Athena Connector

Amazon Athena Connector

Create Amazon Athena policy

Create Amazon Athena policy

Specify the minimum required permissions for Amazon Athena Connector to read data from views and external tables in the AWS Glue data catalog and to read and query Amazon S3 files.
You can use the following minimum required permissions:
  • GetWorkGroup
  • GetTableMetadata
  • StartQueryExecution
  • GetQueryResultsStream
  • ListDatabases
  • GetQueryExecution
  • GetQueryResults
  • GetDatabase
  • ListTableMetadata
  • GetDataCatalog
Sample Policy
:
{ "Version": "2012-10-17", "Statement": [ { "Effect": "Allow", "Action": [ "athena:GetWorkGroup", "athena:GetTableMetadata", "athena:StartQueryExecution", "athena:GetQueryResultsStream", "athena:ListDatabases", "athena:GetQueryExecution", "athena:GetQueryResults", "athena:GetDatabase", "athena:ListTableMetadata", "athena:GetDataCatalog" ], "Resource": [ "arn:aws:athena:*:*:workgroup/*", "arn:aws:athena:*:*:datacatalog/*" ] }, { "Effect": "Allow", "Action": [ "athena:ListDataCatalogs", "athena:ListWorkGroups" ], "Resource": "*" } ] }