The Run Athena Query action can be used to run an Athena SQL query at a specific time of day. Once the query has been executed, the results can be emailed.

Please see Common Action Settings for a description of settings common to all action types.

Query Type

Indicate the type/source of the query string. Valid options are:

Query Name

Name of the saved Athena query to use.

Query String

Query string to use when executing the query. This should be valid Athena SQL.

Output Bucket Name

Name of the S3 bucket where Athena will output the query results.

Output Prefix

Prefix to use for the output objects when Athena outputs the query results.

Output Encryption Method

Encryption method to use when Athena outputs the query results. Valid values are:

Output KMS Key ID

ID, ARN, or alias of the KMS key to use for server-side encryption.

Target Type

Type of target where the results will be sent. Valid values are:

Target Email

Indicates where the results will be sent. Valid values are:

Alternate Email Addresses

Indicates the alternate email addresses to send the query results. Email addresses should be one per line.

Report Format

Format of the results. Valid values are:

The following Amazon AWS commands are used. The access key should have permission to execute all of them.