Download multiple recent queries to a CSV file - Amazon Athena
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Download multiple recent queries to a CSV file

You can use the Recent queries tab of the Athena console to export one or more recent queries to a CSV file in order to view them in tabular format. The downloaded file contains not the query results, but the SQL query string itself and other information about the query. Exported fields include the execution ID, query string contents, query start time, status, run time, amount of data scanned, query engine version used, and encryption method. You can export a maximum of 500 recent queries, or a filtered maximum of 500 queries using criteria that you enter in the search box.

To export one or more recent queries to a CSV file
  1. Open the Athena console at https://console.amazonaws.cn/athena/.

  2. Choose Recent queries.

  3. (Optional) Use the search box to filter for the recent queries that you want to download.

  4. Choose Download CSV.

    Choose Download CSV.
  5. At the file save prompt, choose Save. The default file name is Recent Queries followed by a timestamp (for example, Recent Queries 2022-12-05T16 04 27.352-08 00.csv)