Query Athena

How to use an AWS Step Functions state machine to query Athena and get the results by leveraging Step Functionsnative integration with Amazon Athena

This sample project demonstrates how to use an AWS Step Functions state machine to query Athena and get the results.
This pattern is leveraging the native integration between these 2 services which means only JSON-based, structured language is used to define the implementation.
With Amazon Athena you can get up to 1000 results per invocation of the GetQueryResults method and this is the reason why the Step Functionshas a loop to get more results.

< Back to all workflows

GitHub icon View this workflow on GitHub


Clone repo

git clone https://github.com/aws-samples/serverless-patterns/tree/main/sfn-athena-cdk-python/cd step-functions-workflows-collection/sfn-athena-cdk-python/

Deploy

See the GitHub repo for detailed testing instructions.


Testing

See the GitHub repo for detailed testing instructions.

Cleanup

See the GitHub repo for detailed testing instructions.

Created by:

Corneliu Croitoru

Corneliu Croitoru

Developer at heart, in 2018 joined AWS as a Solution Architect and since 2021 building, jointly with customers, the most exciting and innovative prototypes on AWS.

Follow on LinkedIn