Actions, resources, and condition keys for Amazon Athena - Service Authorization Reference

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 types 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 Actions table.

Actions Description Access level Resource types (*required) Condition keys Dependent actions
BatchGetNamedQuery Grants permission to get information about one or more named queries Read

workgroup*

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

workgroup*

CreateDataCatalog Grants permission to create a datacatalog Write

datacatalog*

aws:RequestTag/${TagKey}

aws:TagKeys

CreateNamedQuery Grants permission to create a named query Write

workgroup*

CreatePreparedStatement Grants permission to create a prepared statement Write

workgroup*

CreateWorkGroup Grants permission to create a workgroup Write

workgroup*

aws:RequestTag/${TagKey}

aws:TagKeys

DeleteDataCatalog Grants permission to delete a datacatalog Write

datacatalog*

DeleteNamedQuery Grants permission to delete a named query specified Write

workgroup*

DeletePreparedStatement Grants permission to delete a prepared statement specified Write

workgroup*

DeleteWorkGroup Grants permission to delete a workgroup Write

workgroup*

GetDataCatalog Grants permission to get a datacatalog Read

datacatalog*

GetDatabase Grants permission to get a database for a given datacatalog Read

datacatalog*

GetNamedQuery Grants permission to get information about the specified named query Read

workgroup*

GetPreparedStatement Grants permission to get information about the specified prepared statement Read

workgroup*

GetQueryExecution Grants permission to get information about the specified query execution Read

workgroup*

GetQueryResults Grants permission to get the query results Read

workgroup*

GetQueryResultsStream Grants permission to get the query results stream Read

workgroup*

GetTableMetadata Grants permission to get a metadata about a table for a given datacatalog Read

datacatalog*

GetWorkGroup Grants permission to get a workgroup Read

workgroup*

ListDataCatalogs Grants permission to return a list of datacatalogs for the specified AWS account List
ListDatabases Grants permission to return a list of databases for a given datacatalog List

datacatalog*

ListEngineVersions Grants permission to return a list of athena engine versions for the specified AWS account Read
ListNamedQueries Grants permission to return a list of named queries in Amazon Athena for the specified AWS account List

workgroup*

ListPreparedStatements Grants permission to return a list of prepared statements for the specified workgroup List

workgroup*

ListQueryExecutions Grants permission to return a list of query executions for the specified AWS account Read

workgroup*

ListTableMetadata Grants permission to return a list of table metadata in a database for a given datacatalog Read

datacatalog*

ListTagsForResource Grants permission to return a list of tags for a resource Read

datacatalog*

workgroup*

ListWorkGroups Grants permission to return a list of workgroups for the specified AWS account List
StartQueryExecution Grants permission to start a query execution using an SQL query provided as a string Write

workgroup*

StopQueryExecution Grants permission to stop the specified query execution Write

workgroup*

TagResource Grants permission to add a tag to a resource Tagging

datacatalog*

workgroup*

aws:RequestTag/${TagKey}

aws:TagKeys

UntagResource Grants permission to remove a tag from a resource Tagging

datacatalog*

workgroup*

aws:TagKeys

UpdateDataCatalog Grants permission to update a datacatalog Write

datacatalog*

UpdateNamedQuery Grants permission to update a named query specified Write

workgroup*

UpdatePreparedStatement Grants permission to update a prepared statement Write

workgroup*

UpdateWorkGroup Grants permission to update a workgroup Write

workgroup*

Resource types 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 Resource types table.

Resource types ARN Condition keys
datacatalog arn:${Partition}:athena:${Region}:${Account}:datacatalog/${DataCatalogName}

aws:ResourceTag/${TagKey}

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 Condition keys table.

To view the global condition keys that are available to all services, see Available global condition keys.

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