Amazon Athena - Execute Query

Overview

First time using this Blueprint? Make sure you follow our Athena authorization guide.

Execute any SQL query against Amazon Athena. Perfect for creating multi-step SQL jobs, executing DML statements, or running scheduled queries.

Variables

Name	Reference	Type	Required	Default	Options	Description
Database	ATHENA_DATABASE	Alphanumeric	✅	-	-	The name of the Athena database the run the query against.
Query	ATHENA_QUERY	Alphanumeric	✅	-	-	The SQL-style query to run against the Athena database.
S3 Log Bucket Name	ATHENA_BUCKET_NAME	Alphanumeric	✅	-	-	The S3 bucket to output the query logs into.
S3 Log Folder Name	ATHENA_LOG_FOLDER	Alphanumeric	➖	-	-	The optional subdirectory within the S3 bucket to store query logs.
Access Key ID	AWS_ACCESS_KEY_ID	Password	✅	-	-	The access key ID for programmatic IAM user used to download the file. See Authorization documentation for more information.
Secret Access Key	AWS_SECRET_ACCESS_KEY	Password	✅	-	-	The secret access key for programmatic IAM user used to download the file. See Authorization documentation for more information.
Region	AWS_DEFAULT_REGION	Select	✅	us-east-2	us-east-2, us-east-1, us-west-1, us-west-2, af-south-1, ap-east-1, ap-south-1, ap-northeast-3, ap-northeast-2, ap-southeast-1, ap-southeast-2, ap-northeast-1, ca-central-1, cn-north-1, cn-northwest-1, eu-central-1, eu-west-1, eu-west-2, eu-south-1, eu-west-3, eu-north-1, sa-east-1, me-south-1	The AWS region for the S3 bucket and IAM user.

YAML

Below is the YAML template for this Blueprint and can be used in the Fleet YAML Editor.

source:
  blueprint: Amazon Athena - Execute Query
  inputs:
    ATHENA_DATABASE: null ## REQUIRED
    ATHENA_QUERY: null ## REQUIRED
    ATHENA_BUCKET_NAME: null ## REQUIRED
    ATHENA_LOG_FOLDER: null 
    AWS_ACCESS_KEY_ID: null ## REQUIRED
    AWS_SECRET_ACCESS_KEY: null ## REQUIRED
    AWS_DEFAULT_REGION: us-east-2 ## REQUIRED
  type: BLUEPRINT
guardrails:
  retry_count: 1
  retry_wait: 0s
  runtime_cutoff: 4h0m0s
  exclude_exit_code_ranges:
    - "0"