Athena Query

This is a simple no frills query that you want to run using Athena:

“Run Time” is the Time in UTC time zone when you want the job to run.

“Number of Runs per day” is the number of times per day you want the job to run. This could be anywhere from 1 to 1440 times per day (every minute is currently the maximum)

Fill in the “Email address” to be receive job run notifications by email. This only works if you’ve signed up for SendGrid and completed the details in the SendGrid section:

“Pipeline Name” groups jobs together to run consecutively and dependently. This means subsequent job steps eg: Step 2 will only run once Step 1 has completed successfully. To change the Pipeline that the job belongs to, simply change the Pipeline Name field.

“Region” is the AWS region where you want the query to run.

“Job Name” is the unique name of the job. It can’t exist even in a different pipeline.

“Athena SQL statement” is the path to the file containing your SQL statement in S3. Exclude the “s3://” prefix.

“Athena Query Result Location” is the S3 location where you want the query results saved.

“Athena Database” is the database to use in Athena.

Leave a Comment