Process results from Amazon Athena Queries written to Amazon S3.
When running SQL queries using Amazon Athena, the query results can be stored in specified locations. One potential location is Amazon S3 to view and download the query result sets for different postprocessing use cases. Amazon Athena automatically stores query results and metadata information for each query that runs in a query result location that you can specify in Amazon S3. If necessary, you can access the files in this location to work with them. You can also download query result files directly from the Amazon Athena console.
< Back to all workflows
Clone repo
git clone https://github.com/aws-samples/step-functions-workflows-collection/tree/main/tree/main/sfn-athena-results/cd step-functions-workflows-collection/sfn-athena-results/
Deploy
sam deploy --guided
Testing
See the GitHub repo for detailed testing instructions.
Cleanup
1. Delete the stack:
sam delete --stack-name STACK_NAME.2. Confirm the stack has been deleted:
aws cloudformation list-stacks --query "StackSummaries[?contains(StackName,'STACK_NAME')].StackStatus"Additional resources
Created by:
