Start Athena Query

This workflow use Step Functions and Amazon Athena and AWS Lambda Functions to start an Athena query and send a notification via SNS with query results.

In this project, Step Functions invokes a Lambda function to generate data, then, another Lambda function is invoked, which uses a Glue crawler, to categorize data stored in S3.
The Athena query is then initiated and runs until it is completed. Once the query is completed, the results are obtained and published to the SNS (Simple Notification Service) topic.

< Back to all workflows

GitHub icon View this workflow on GitHub


Clone repo

git clone https://github.com/aws-samples/step-functions-workflows-collection/tree/main/sfn-start-athena-query-tf/cd step-functions-workflows-collection/sfn-start-athena-query-tf

Deploy

terraform initterraform apply


Testing

See the GitHub repo for detailed testing instructions.

Cleanup

1. Delete the stack: terraform destroy.

Additional resources

Created by:

Itziar Olivera Goicolea

Itziar is a Technical Account Manager at AWS from Iberia (EMEA).

Follow on LinkedIn