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:

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: