AWSQuicksightAthenaAccess
Summary
Quicksight access to Athena API and S3 buckets used for Athena query results
Permissions imported from the AWS Managed Policy Reference Guide; other sections pending editorial review.
Identity
- ARN
arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccess- Default version
- v13
- Created
- Last edited
- Services
- athena, glue, lakeformation, s3
Control-plane actions (52)
By access level: 4 List, 1 Permissions management, 29 Read, 18 Write.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| Athena | 26 of 86 | 3 List, 19 Read, 4 Write; 0 restricted, 0 conditional | athena:BatchGetQueryExecution, athena:CancelQueryExecution, athena:GetCatalogs, athena:GetDataCatalog, athena:GetDatabase, athena:GetExecutionEngine, athena:GetExecutionEngines, athena:GetNamespace, athena:GetNamespaces, athena:GetQueryExecution, athena:GetQueryExecutions, athena:GetQueryResults and 14 more |
| Glue | 21 of 306 | 9 Read, 12 Write; 0 restricted, 0 conditional | glue:BatchCreatePartition, glue:BatchDeletePartition, glue:BatchDeleteTable, glue:BatchGetPartition, glue:CreateDatabase, glue:CreatePartition, glue:CreateTable, glue:DeleteDatabase, glue:DeletePartition, glue:DeleteTable, glue:GetCatalog, glue:GetCatalogs and 9 more |
| Lake Formation | 1 of 68 | 1 Write; 0 restricted, 0 conditional | lakeformation:GetDataAccess |
| S3 | 4 of 155 | 1 List, 1 Permissions management, 1 Read, 1 Write; 4 restricted, 0 conditional | s3:CreateBucket, s3:GetBucketLocation, s3:ListBucketMultipartUploads, s3:PutBucketPublicAccessBlock |
Athena: 26 actions
- athena:BatchGetQueryExecution (Read)
- athena:CancelQueryExecution (Write)
- athena:GetCatalogs (Read)
- athena:GetDataCatalog (Read)
- athena:GetDatabase (Read)
- athena:GetExecutionEngine (Read)
- athena:GetExecutionEngines (Read)
- athena:GetNamespace (Read)
- athena:GetNamespaces (Read)
- athena:GetQueryExecution (Read)
- athena:GetQueryExecutions (Read)
- athena:GetQueryResults (Read)
- athena:GetQueryResultsStream (Read)
- athena:GetTable (Read)
- athena:GetTableMetadata (Read)
- athena:GetTables (Read)
- athena:GetWorkGroup (Read)
- athena:ListDataCatalogs (List)
- athena:ListDatabases (List)
- athena:ListEngineVersions (Read)
- athena:ListQueryExecutions (Read)
- athena:ListTableMetadata (Read)
- athena:ListWorkGroups (List)
- athena:RunQuery (Write)
- athena:StartQueryExecution (Write)
- athena:StopQueryExecution (Write)
Glue: 21 actions
- glue:BatchCreatePartition (Write)
- glue:BatchDeletePartition (Write)
- glue:BatchDeleteTable (Write)
- glue:BatchGetPartition (Read)
- glue:CreateDatabase (Write)
- glue:CreatePartition (Write)
- glue:CreateTable (Write)
- glue:DeleteDatabase (Write)
- glue:DeletePartition (Write)
- glue:DeleteTable (Write)
- glue:GetCatalog (Read)
- glue:GetCatalogs (Read)
- glue:GetDatabase (Read)
- glue:GetDatabases (Read)
- glue:GetPartition (Read)
- glue:GetPartitions (Read)
- glue:GetTable (Read)
- glue:GetTables (Read)
- glue:UpdateDatabase (Write)
- glue:UpdatePartition (Write)
- glue:UpdateTable (Write)
Lake Formation: 1 actions
- lakeformation:GetDataAccess (Write)
S3: 4 actions
- s3:CreateBucket (Write)
- s3:GetBucketLocation (Read)
- s3:ListBucketMultipartUploads (List)
- s3:PutBucketPublicAccessBlock (Permissions management)
Data-plane actions (5)
By access level: 2 List, 1 Read, 2 Write.
| Service | Granted | Access levels and limits | Granted by |
|---|---|---|---|
| S3 | 5 of 25 | 2 List, 1 Read, 2 Write; 5 restricted, 0 conditional | s3:AbortMultipartUpload, s3:GetObject, s3:ListBucket, s3:ListMultipartUploadParts, s3:PutObject |
S3: 5 actions
- s3:AbortMultipartUpload (Write)
- s3:GetObject (Read)
- s3:ListBucket (List)
- s3:ListMultipartUploadParts (List)
- s3:PutObject (Write)
Excluded and conditional actions
No patterns are excluded by NotAction or Deny statements.
Resource scope and attachment
Resource scope across granted actions: mixed.
Can be attached: Yes, to users, groups and roles.
Why this tier
- Grants 20 write, tagging or permissions-management actions, short of full control of any service.
- Grants data-plane write actions on a data store, but only for scoped resources or under conditions.
Guidance
Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.
Related policies
Same service
- AccessAnalyzerServiceRolePolicy
- AdministratorAccess-AWSElasticBeanstalk
- AmazonAppFlowFullAccess
- AmazonAppStreamServiceAccess
- AmazonAthenaFullAccess
- AmazonBedrockStudioPermissionsBoundary
- AmazonBraketJobsExecutionPolicy
- AmazonBraketServiceRolePolicy
Same domain
- AmazonChimeSDKMediaPipelinesServiceLinkedRolePolicy
- AmazonChimeSDKMessagingServiceRolePolicy
- AmazonDataZoneDomainExecutionRolePolicy
- AmazonDataZoneEnvironmentRolePermissionsBoundary
- AmazonDataZoneFullAccess
- AmazonDataZoneFullUserAccess
- AmazonDataZoneGlueManageAccessRolePolicy
- AmazonDataZoneProjectRolePermissionsBoundary
Frequently asked questions
Pending editorial review. The permission data on this page comes straight from AWS; this section will be filled in once a reviewed guide exists.
Policy JSON
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Action": [
"athena:BatchGetQueryExecution",
"athena:CancelQueryExecution",
"athena:GetCatalogs",
"athena:GetExecutionEngine",
"athena:GetExecutionEngines",
"athena:GetNamespace",
"athena:GetNamespaces",
"athena:GetQueryExecution",
"athena:GetQueryExecutions",
"athena:GetQueryResults",
"athena:GetQueryResultsStream",
"athena:GetTable",
"athena:GetTables",
"athena:ListQueryExecutions",
"athena:RunQuery",
"athena:StartQueryExecution",
"athena:StopQueryExecution",
"athena:ListWorkGroups",
"athena:ListEngineVersions",
"athena:GetWorkGroup",
"athena:GetDataCatalog",
"athena:GetDatabase",
"athena:GetTableMetadata",
"athena:ListDataCatalogs",
"athena:ListDatabases",
"athena:ListTableMetadata"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"glue:CreateDatabase",
"glue:DeleteDatabase",
"glue:GetCatalog",
"glue:GetCatalogs",
"glue:GetDatabase",
"glue:GetDatabases",
"glue:UpdateDatabase",
"glue:CreateTable",
"glue:DeleteTable",
"glue:BatchDeleteTable",
"glue:UpdateTable",
"glue:GetTable",
"glue:GetTables",
"glue:BatchCreatePartition",
"glue:CreatePartition",
"glue:DeletePartition",
"glue:BatchDeletePartition",
"glue:UpdatePartition",
"glue:GetPartition",
"glue:GetPartitions",
"glue:BatchGetPartition"
],
"Resource": [
"*"
]
},
{
"Effect": "Allow",
"Action": [
"s3:GetBucketLocation",
"s3:GetObject",
"s3:ListBucket",
"s3:ListBucketMultipartUploads",
"s3:ListMultipartUploadParts",
"s3:AbortMultipartUpload",
"s3:CreateBucket",
"s3:PutObject",
"s3:PutBucketPublicAccessBlock"
],
"Resource": [
"arn:aws:s3:::aws-athena-query-results-*"
]
},
{
"Effect": "Allow",
"Action": [
"lakeformation:GetDataAccess"
],
"Resource": [
"*"
]
}
]
}
Version history
Current version v13, edited by AWS on 2026-02-12. Version history is recorded from 2026-11-11. Earlier versions are in the IAM console under Policy versions.
Attach snippets
AWS CLI
aws iam attach-role-policy --role-name ROLE_NAME --policy-arn arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccess
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccess
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccessCloudFormation
Resources:
ExampleRole:
Type: AWS::IAM::Role
Properties:
AssumeRolePolicyDocument: {} # replace with your trust policy
ManagedPolicyArns:
- arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccessTerraform
resource "aws_iam_role_policy_attachment" "service_role_awsquicksightathenaaccess" {
role = aws_iam_role.example.name
policy_arn = "arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccess"
}CDK (TypeScript)
role.addManagedPolicy(
iam.ManagedPolicy.fromAwsManagedPolicyName("service-role/AWSQuicksightAthenaAccess"),
);Sources
Pending editorial review. No editorial sources are listed yet.