Creating Databases in Athena - Amazon Athena

Creating Databases in Athena

A database in Athena is a logical grouping for tables you create in it. Creating a database in the Athena console Query Editor is straightforward.

To create a database using the Athena Query Editor

  1. Open the Athena console at https://console.aws.amazon.com/athena/.

  2. On the Query Editor tab, enter the Hive data definition language (DDL) command CREATE DATABASE myDataBase. Replace myDatabase with the name of the database that you want to create.

    
                    Creating a database in the Athena Query Editor.
  3. Choose Run Query or press Ctrl+ENTER.

  4. To make your database the current database, select it from from the Database menu.

    Note

    Currently, the database menu can show and filter a maximum of 1000 databases regardless of the type of data catalog used. This is a limitation of the Athena console, not an account limit. The number of databases that can be displayed and filtered is not user configurable.

    
                    Choosing a database in the Athena console.

For information on controlling permissions to Athena databases, see Fine-Grained Access to Databases and Tables in the AWS Glue Data Catalog.