Retrieving Athena Query History data

Hi

Thank you for posting your concerns on AWS Forums.

I understand you would like to get Athena query history data like data scanned and execution time for Athena queries without using get-query-execution.

I am afraid that statistics like DataScannedInBytes and EngineExecutionTimeInMillis are not stored in S3, only the result of a Query is stored in CSV format. Therefore, it would be required for you to use the get-query-execution API to get there statistics.

Alternatively, if you do not require per Query statistic and get the over statistics by all Athena queries, and use Cloudwatch metrics for a work group to track the usage.
Athena publishes the following metrics to the CloudWatch console:
Query Status (successful, failed, or canceled)
Query Execution Time (in seconds)
Query Type (DDL or DML)
Data Processed Per Query. This is the total amount of data scanned per query (in Megabytes).
Workgroup Name

If feasible, you can leverage the above metrics for your use-case.

Please refer https://docs.aws.amazon.com/athena/latest/ug/query-metrics-viewing.html for more details.

I hope this helps. Please reply on this thread in case you have any further concerns.

Have a nice day!

Regards,
Almas S.