I am running queries using the Amazon Athena console. Where can I find the results of my queries?
When you run a query using Athena, you can access the results of your query using one of the following ways:
To download the results of a query through the Athena console
If you want to download the results of an Athena query that you ran from the Athena console, choose the folder icon in the upper-right corner of the Results pane. Your browser will download the query results in .csv format.
You can also download the results of a query that you ran recently from the Athena console:
- From the Athena console, open the History pane.
- Find your query, and under Action, choose Download results.
To download the results from an Amazon Simple Storage Service (S3) bucket
When you run an Athena query for the first time, an S3 bucket called "aws-athena-query-results-<account_id>" is created on your account, where "<account_id>" is replaced with your AWS account ID.
The results of all Athena queries are stored in this S3 bucket using the year, month, and day the query was run, the hexadecimal Athena query ID, and the region the query was run in the following format:
aws-athena-query-results-{account_id}-{region}/Unsaved/{year}/{month}/{day}/{query_id}.csv
After you save the query, it is stored in an S3 bucket in the following format:
aws-athena-query-results-{account_id}-{region}/{SavedQueryName}/{year}/{month}/{day}/{QueryID}.csv
You can access the results of any query from these S3 buckets without having to sign in to the Athena console and then download it.
To change the bucket where results are stored, update the bucket location by choosing Settings in the Athena console.
Did this page help you? Yes | No
Back to the AWS Support Knowledge Center
Need help? Visit the AWS Support Center
Published: 2016-12-15
Updated: 2018-03-06
