Webinar: Get Hands-On With ServerlessRegister now

Using AWS Step Functions to query Amazon Athena Amazon S3 data

AWS Step Functions → Amazon Athena → AWS Glue → Amazon S3

Using Step Functions to query Athena S3 data.

This serverless pattern uses Amazon Athena allows to analyze data in Amazon S3 using standard SQL.
A Glue crawler creates a database table from the S3 data which is queried by Athena.
Step Functionsis leveraged to query as well as process each result in this data received from Athena with the help of **NextToken**.

< Back to all patterns
Language:
Python
Framework:
AWS SAM

GitHub icon Download this pattern (.zip)

GitHub icon View this pattern on GitHub

Clone repo

git clone https://github.com/aws-samples/serverless-patterns/cd serverless-patterns/step-functions-athena-glue-sam

Deploy

sam deploy --guided

Testing

See the GitHub repo for detailed testing instructions.

Cleanup

Delete the stack: same delete.

Additional resources

Created by:

Abhishek Agawane

Abhishek Agawane

Abhishek is a Security Consultant at Amazon Web Services with more than 9 years of industry experience. He helps organizations architect resilient, secure, and efficient cloud environments, guiding them through complex challenges and large-scale infrastructure transformations. He has helped numerous organizations enhance their cloud operations through targeted optimizations, robust architectures, and best-practice implementations.