Skip to main content
IAM Policy Map

AWSQuicksightAthenaAccess

OperatorService roleActivePermissions reviewedShow on mapCompare

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.

Control-plane actions by service
ServiceGrantedAccess levels and limitsGranted by
Athena26 of 863 List, 19 Read, 4 Write; 0 restricted, 0 conditionalathena: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
Glue21 of 3069 Read, 12 Write; 0 restricted, 0 conditionalglue: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 Formation1 of 681 Write; 0 restricted, 0 conditionallakeformation:GetDataAccess
S34 of 1551 List, 1 Permissions management, 1 Read, 1 Write; 4 restricted, 0 conditionals3: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.

Data-plane actions by service
ServiceGrantedAccess levels and limitsGranted by
S35 of 252 List, 1 Read, 2 Write; 5 restricted, 0 conditionals3: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.

Same service

Same domain

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

Download 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/AWSQuicksightAthenaAccess

CloudFormation

Resources:
  ExampleRole:
    Type: AWS::IAM::Role
    Properties:
      AssumeRolePolicyDocument: {}  # replace with your trust policy
      ManagedPolicyArns:
        - arn:aws:iam::aws:policy/service-role/AWSQuicksightAthenaAccess

Terraform

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.