Amazon Athena query history report

To retrieve and save query history programmatically:

1. Use Athena ListQueryExecutions API action or the list-query-executions CLI command to retrieve the query IDs.
2. Use the Athena GetQueryExecution API action or the get-query-execution CLI command to retrieve information about each query based on its ID.
3. Use the Amazon S3 PutObject API action or the put-object CLI command to save the information in Amazon S3.

Please check Working with Query Results, Output Files, and Query History for more details.