Skip to main content

Create and Manage Databases

Create a database​

A database is a container that stores tables. To create a database, a catalog must already exist.
Once the catalog status changes to Running, you can create databases in that catalog.
Follow the steps below to create a database in the Data Catalog service.

  1. Go to the KakaoCloud console > Analytics > Data Catalog.

  2. In the Database menu, click Create database.

  3. In the Create database pop-up window, enter the following information and click Create.

    FieldDescription
    TypeSelect the database type.
    - Standard database
    - Iceberg database
    CatalogSelect the catalog to which the database will be added.
    - Only catalogs matching the selected type are shown.
    NameName of the database
    PathEnter the Object Storage path that the database will use.
    - Bucket selection: Choose an Object Storage bucket
    - Directory: Enter a subdirectory path within the bucket

    * Note:
    - Table paths inherit from the database path.
    - When creating a table using Hive, Spark, or Trino without specifying a path, it is automatically set under the database path as \{database location\}/\{table_name\}.
    - The full path is set in the format s3a://.
    Properties (optional)Add database properties
    Description (optional)Enter a description for the database

Manage databases​

This section explains how to manage databases in the Data Catalog service.

View database list​

You can view the list of created databases and their basic information.

  1. Go to the KakaoCloud console > Analytics > Data Catalog.

  2. Click Database to view the list.

    ColumnDescription
    NameName of the database specified by the user
    Associated catalogName of the catalog the database belongs to
    StatusCurrent status of the database
    - For detailed descriptions of each state, see Resource status and lifecycle.
    TypeDatabase type
    - Standard database or Iceberg database
    PathPath where the database is located
    Created atDate the database was created
    Created byUser who created the database
    [More] icon- Edit database: Modify the database path or description
    - Delete database: Delete the database
    * When in the INACTIVE state, only deletion is available — editing is not allowed.

View database details​

View detailed information about a database.

  1. Go to the KakaoCloud console > Analytics > Data Catalog.
  2. Select the Database menu, then choose the database to view.
  3. Review the database information on the details page.

Summary information

FieldDescription
Associated catalogName of the catalog linked to the database
IDUUID of the database
TypeDatabase type
- Standard or Iceberg
PathPath where the database is located
Created atDate the database was created

Basic information

FieldDescription
Table nameName of the table created by the user
DescriptionDescription entered by the user
StatusStatus of the table
- For details, see Resource status and lifecycle.
Table typeTable type
- Standard or Iceberg
Data typeData format used in the table

Standard table types
- JSON, ORC, Parquet, CSV, Avro, text, custom
ㄴ Tables created and migrated via Hadoop Eco may appear as text or custom.
ㄴ text: When the SerDe library is org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
ㄴ custom: When the table format does not fall under Avro, JSON, Parquet, ORC, CSV, or text

Iceberg table types
- Avro, Parquet, ORC
Data storage pathPath where table data is stored
Last modifiedDate when the table was last modified

Modify database​

You can modify only the path and description of a database.
Database names and associated catalogs cannot be changed. To change them, create a new database.

  1. Go to the KakaoCloud console > Analytics > Data Catalog.

  2. In the Database menu, click the [More] icon next to the target database and select Edit database.

  3. In the Edit database pop-up, modify the information and click Update.

    FieldDescription
    Path (optional)Modify the database location
    - Bucket name: Select an Object Storage bucket
    - Directory: Enter a subdirectory path within the bucket
    - Note: The full path is set in the s3a:// format.
    Description (optional)Modify the database description
    - Not available for Standard database type.

Delete database​

Delete databases that are no longer in use.

caution

Once deleted, database resources are permanently released and cannot be recovered.
All tables under the deleted database are also deleted permanently and cannot be restored.

  1. Go to the KakaoCloud console > Analytics > Data Catalog.
  2. In the Database menu, click the [More] icon next to the target database and select Delete database.
    • To delete multiple databases at once, select the checkboxes next to them and click Delete at the bottom.
  3. In the Delete database pop-up, review the database information, enter Permanently delete or the database name, and click Delete.