Create a query output location - 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).

Create a query output location

If you do not already have a query output location set up in Amazon S3, perform the following prerequisite steps to do so.

To create a query output location

  1. Using the same Amazon Web Services Region and account that you are using for Athena, follow the steps (for example, by using the Amazon S3 console) to create a bucket in Amazon S3 to hold your Athena query results. You will configure this bucket to be your query output location.

  2. Open the Athena console at https://console.amazonaws.cn/athena/.

  3. If this is your first time to visit the Athena console in this Amazon Web Services Region, choose Explore the query editor to open the query editor. Otherwise, Athena opens in the query editor.

  4. Choose Edit Settings to set up a query result location in Amazon S3.

    Choose Edit settings.

  5. For Manage settings, do one of the following:

    • In the Location of query result box, enter the path to the bucket that you created in Amazon S3 for your query results. Prefix the path with s3://.

    • Choose Browse S3, choose the Amazon S3 bucket that you created for your current Region, and then choose Choose.

    Specify a location in Amazon S3 to receive query results from Athena.

  6. Choose Save.

  7. Choose Editor to switch to the query editor.

    Choose Editor.