Step 1: Create a database - 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).

Step 1: Create a database

You first need to create a database in Athena.

To create an Athena database

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

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

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

    Choose Edit settings.

  4. 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.

  5. Choose Save.

  6. Choose Editor to switch to the query editor.

    Choose Editor.

  7. On the right of the navigation pane, you can use the Athena query editor to enter and run queries and statements.

    The query editor in the Athena console.

  8. To create a database named mydatabase, enter the following CREATE DATABASE statement.

    CREATE DATABASE mydatabase

  9. Choose Run or press Ctrl+ENTER.

  10. From the Database list on the left, choose mydatabase to make it your current database.

    Choose the database that you created.