AWS Identity and Access Management
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

Actions, Resources, and Condition Keys for Amazon Athena

Amazon Athena (service prefix: athena) provides the following service-specific resources, actions, and condition context keys for use in IAM permission policies.

References:

Actions Defined by Amazon Athena

You can specify the following actions in the Action element of an IAM policy statement. Use policies to grant permissions to perform an operation in AWS. When you use an action in a policy, you usually allow or deny access to the API operation or CLI command with the same name. However, in some cases, a single action controls access to more than one operation. Alternatively, some operations require several different actions.

The Resource column indicates whether each action supports resource-level permissions. If there is no value for this column, you must specify all resources ("*") in the Resource element of your policy statement. If the column includes a resource type, then you can specify an ARN of that type in a statement with that action. Required resources are indicated in the table with an asterisk (*). If you specify a resource-level permission ARN in a statement using this action, then it must be of this type. Some actions support multiple resource types. If the resource type is optional (not indicated as required), then you can choose to use one but not the other.

For details about the columns in the following table, see The Actions Table.

Actions Description Access Level Resource Types (*required) Condition Keys Dependent Actions
BatchGetNamedQuery Grants permissions to get information about one or more named queries. Read

workgroup*

BatchGetQueryExecution Grants permissions to get information about one or more query executions. Read

workgroup*

CancelQueryExecution Deprecated. Applies only to AWS services and principals that use Athena JDBC driver earlier than 1.1.0. Use StopQueryExecution otherwise. Write

workgroup*

CreateNamedQuery Grants permissions to create a named query. Write

workgroup*

CreateWorkGroup Grants permissions to create a workgroup. Tagging

workgroup*

aws:RequestTag/${TagKey}

aws:TagKeys

DeleteNamedQuery Grants permissions to delete a named query specified. Write

workgroup*

DeleteWorkGroup Grants permissions to delete a workgroup. Write

workgroup*

GetCatalogs Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to databases and tables. Read
GetExecutionEngine Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to the specified database and table. Read
GetExecutionEngines Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to databases and tables. Read
GetNamedQuery Grants permissions to get information about the specified named query. Read

workgroup*

GetNamespace Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to the specified database and table. Read
GetNamespaces Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to databases and tables. Read
GetQueryExecution Grants permissions to get information about the specified query execution. Read

workgroup*

GetQueryExecutions Deprecated. Applies only to AWS services and principals that use Athena JDBC driver earlier than 1.1.0. Use ListQueryExecutions otherwise. Read
GetQueryResults Grants permissions to get the query results. Read

workgroup*

GetQueryResultsStream Grants permissions to get the query results stream. Read

workgroup*

GetTable Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to the specified table. Read
GetTables Applies only to AWS services managed policy and principals that use an Athena JDBC driver version 1.1.0. Grants permissions to enable access to tables. Read
GetWorkGroup Grants permissions to get a workgroup. Read

workgroup*

ListNamedQueries Grants permissions to return a list of named queries in Amazon Athena for the specified AWS account. List

workgroup*

ListQueryExecutions Grants permissions to return a list of query executions for the specified AWS account. List

workgroup*

ListTagsForResource Grants permissions to return a list of tags for a workgroup. Read

workgroup*

ListWorkGroups Grants permissions to return a list of workgroups for the specified AWS account. List
RunQuery Deprecated. Applies only to AWS services and principals that use Athena JDBC driver earlier than 1.1.0. Use StartQueryExecution otherwise. Write
StartQueryExecution Grants permissions to start a query execution using an SQL query provided as a string. Write

workgroup*

StopQueryExecution Grants permissions to stop the specified query execution. Write

workgroup*

TagResource Grants permissions to add a tag to a workgroup. Tagging

workgroup*

aws:RequestTag/${TagKey}

aws:TagKeys

UntagResource Grants permissions to remove a tag from a workgroup. Tagging

workgroup*

aws:TagKeys

UpdateWorkGroup Grants permissions to update a workgroup. Write

workgroup*

Resources Defined by Amazon Athena

The following resource types are defined by this service and can be used in the Resource element of IAM permission policy statements. Each action in the Actions table identifies the resource types that can be specified with that action. A resource type can also define which condition keys you can include in a policy. These keys are displayed in the last column of the table. For details about the columns in the following table, see The Resource Types Table.

Resource Types ARN Condition Keys
workgroup arn:${Partition}:athena:${Region}:${Account}:workgroup/${WorkGroupName}

aws:ResourceTag/${TagKey}

Condition Keys for Amazon Athena

Amazon Athena defines the following condition keys that can be used in the Condition element of an IAM policy. You can use these keys to further refine the conditions under which the policy statement applies. For details about the columns in the following table, see The Condition Keys Table.

To view the global condition keys that are available to all services, see Available Global Condition Keys in the IAM Policy Reference.

Condition Keys Description Type
aws:RequestTag/${TagKey} Filters actions based on the presence of tag key-value pairs in the request String
aws:ResourceTag/${TagKey} Filters actions based on tag key-value pairs attached to the resource String
aws:TagKeys Filters actions based on the presence of tag keys in the request String