SageMakerStudioQueryExecutionRolePolicy

OperatorService roleActivePermissions reviewedShow on map Compare

Summary

Amazon SageMaker Studio uses this policy when running query executions on federated connections.

Permissions imported from the AWS Managed Policy Reference Guide; other sections pending editorial review.

Identity

ARN: arn:aws:iam::aws:policy/service-role/SageMakerStudioQueryExecutionRolePolicy
Default version: v6
Created: 2025-01-31
Last edited: 2026-02-12
Services: glue, lambda, s3

Control-plane actions (3)

By access level: 3 Read.

Control-plane actions by service
Service	Granted	Access levels and limits	Granted by
Glue	3 of 306	3 Read; 3 restricted, 2 conditional	glue:GetConnection, glue:GetConnections, glue:GetTags

Glue: 3 actions

glue:GetConnection (Read)
glue:GetConnections (Read)
glue:GetTags (Read)

Data-plane actions (3)

By access level: 1 List, 1 Read, 1 Write.

Data-plane actions by service
Service	Granted	Access levels and limits	Granted by
Lambda	1 of 14	1 Write; 1 restricted, 1 conditional	lambda:InvokeFunction
S3	2 of 25	1 List, 1 Read; 2 restricted, 2 conditional	s3:GetObject, s3:ListBucket

Lambda: 1 actions

lambda:InvokeFunction (Write)

S3: 2 actions

s3:GetObject (Read)
s3:ListBucket (List)

Excluded and conditional actions

No patterns are excluded by NotAction or Deny statements.

Resource scope and attachment

Resource scope across granted actions: scoped.

Can be attached: Yes, to users, groups and roles.

Why this tier

Grants 1 write, tagging or permissions-management action, short of full control of any service.

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": [
    {
      "Sid": "GlueGetConnectionOnCatalog",
      "Effect": "Allow",
      "Action": [
        "glue:GetConnection"
      ],
      "Resource": [
        "arn:aws:glue:*:*:catalog"
      ]
    },
    {
      "Sid": "GlueGetConnectionsForProject",
      "Effect": "Allow",
      "Action": [
        "glue:GetConnection",
        "glue:GetConnections",
        "glue:GetTags"
      ],
      "Resource": "arn:aws:glue:*:*:connection/*",
      "Condition": {
        "Null": {
          "aws:ResourceTag/AmazonDataZoneProject": "false"
        }
      }
    },
    {
      "Sid": "S3GetObjectForAthenaSpillBucket",
      "Effect": "Allow",
      "Action": [
        "s3:GetObject"
      ],
      "Resource": [
        "arn:aws:s3:::*/dzd*/*/dev/sys/athena/*"
      ],
      "Condition": {
        "StringEquals": {
          "aws:PrincipalTag/SageMakerStudioQueryExecutionRole": "true"
        }
      }
    },
    {
      "Sid": "S3ListBucketOwnershipCheckForAthenaSpillBucket",
      "Effect": "Allow",
      "Action": [
        "s3:ListBucket"
      ],
      "Resource": [
        "arn:aws:s3:::amazon-sagemaker-*"
      ],
      "Condition": {
        "StringEquals": {
          "aws:PrincipalTag/SageMakerStudioQueryExecutionRole": "true"
        }
      }
    },
    {
      "Sid": "InvokeFunctionPermissionsForAthenaCatalogLambda",
      "Effect": "Allow",
      "Action": "lambda:InvokeFunction",
      "Resource": "arn:aws:lambda:*:*:function:*",
      "Condition": {
        "StringEquals": {
          "aws:PrincipalTag/SageMakerStudioQueryExecutionRole": "true",
          "aws:ResourceTag/federated_athena_datacatalog": "true"
        }
      }
    }
  ]
}

Version history

Current version v6, 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/SageMakerStudioQueryExecutionRolePolicy
aws iam attach-user-policy --user-name USER_NAME --policy-arn arn:aws:iam::aws:policy/service-role/SageMakerStudioQueryExecutionRolePolicy
aws iam attach-group-policy --group-name GROUP_NAME --policy-arn arn:aws:iam::aws:policy/service-role/SageMakerStudioQueryExecutionRolePolicy

CloudFormation

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

Terraform

resource "aws_iam_role_policy_attachment" "service_role_sagemakerstudioqueryexecutionrolepolicy" {
  role       = aws_iam_role.example.name
  policy_arn = "arn:aws:iam::aws:policy/service-role/SageMakerStudioQueryExecutionRolePolicy"
}

CDK (TypeScript)

role.addManagedPolicy(
  iam.ManagedPolicy.fromAwsManagedPolicyName("service-role/SageMakerStudioQueryExecutionRolePolicy"),
);

Sources

Pending editorial review. No editorial sources are listed yet.