Athena Query History and Query Results
To view the history of queries click on History
. You will be able to see all the queries submitted in this workgroup, their State, Run Time and Data scanned. You can also click on Download results to download as csv data.
To see the Query id click on the state - Succeeded or Failed on one of the queries.
Next Open the S3 console by typing S3 in the Services
Once in the S3 console browse to the bucket starting with athena-workshop-<account-id>
You should see something like this. There is a prefix for each Saved Query and Unsaved folder which stores the results of unsaved queries executed from Athena console. Browse one the the prefix Athena_compare_reviews
and you would see the results stored with a query id.
If you don't see Unsaved folder run one of the previous queries in a new Query tab in Athena and check the S3 bucket again.