Skip to main content

named_query

Gets an individual named_query resource

Overview

Namenamed_query
TypeResource
Descriptionnamed_query
Idawscc.athena.named_query

Fields

NameDatatypeDescription
namestringThe query name.
databasestringThe database to which the query belongs.
descriptionstringThe query description.
query_stringstringThe contents of the query with all query statements.
work_groupstringThe name of the workgroup that contains the named query.
named_query_idstringThe unique ID of the query.
regionstringAWS region.

Methods

Currently only SELECT is supported for this resource resource.

Example

SELECT
region,
name,
database,
description,
query_string,
work_group,
named_query_id
FROM awscc.athena.named_query
WHERE data__Identifier = '<NamedQueryId>';

Permissions

To operate on the named_query resource, the following permissions are required:

Read

athena:GetNamedQuery

Delete

athena:DeleteNamedQuery