Resource Type: AWS > Athena > NamedQuery

Resource Context

NamedQuery is a part of the Athena service.

Each NamedQuery lives under a Workgroup.

Controls

The primary controls for AWS > Athena > NamedQuery are:

• Active
• Approved
• CMDB
• Discovery
• Tags

Quick Actions

• Delete from AWS
• Set Tags
• Skip alarm for Active control
• Skip alarm for Active control [90 days]
• Skip alarm for Approved control
• Skip alarm for Approved control [90 days]
• Skip alarm for Tags control
• Skip alarm for Tags control [90 days]

Category

• Database

In Your Workspace

• Controls by Resource Type report
• Policy Settings by Resource Type report
• Resources by Resource Type report

Developers

Resource Type URI

tmod:@turbot/aws-athena#/resource/types/namedQuery

Category URI

tmod:@turbot/turbot#/resource/categories/database

GraphQL

query resource(id: "tmod:@turbot/aws-athena#/resource/types/namedQuery") { … }

query resourceActivities(filter: "resourceId:'tmod:@turbot/aws-athena#/resource/types/namedQuery'") { … }

mutation createResource(input: { … })

mutation updateResource(input: { … })

CLI

Get Resource

turbot graphql resource --id "tmod:@turbot/aws-athena#/resource/types/namedQuery"

Steampipe Query

Get Resource

select * from guardrails_resource where resource_type_uri = 'tmod:@turbot/aws-athena#/resource/types/namedQuery';

Get Policy Settings (By Resource ID)

select * from guardrails_policy_setting where filter = 'resourceTypeId:"tmod:@turbot/aws-athena#/resource/types/namedQuery"';

Get Resource Notification

select * from guardrails_notification where resource_type_uri = 'tmod:@turbot/aws-athena#/resource/types/namedQuery' and notification_type in ('resource_updated', 'resource_created');