Create and manage databases

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

   Field	Description
   Type	Select the database type. - Standard database - Iceberg database
   Catalog	Select the catalog to which the database will be added. - Only catalogs matching the selected type are shown.
   Name	Name of the database
   Path	Enter 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

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.

   Column	Description
   Name	Name of the database specified by the user
   Associated catalog	Name of the catalog the database belongs to
   Status	Current status of the database - For detailed descriptions of each state, see Resource status and lifecycle.
   Type	Database type - Standard database or Iceberg database
   Path	Path where the database is located
   Created at	Date the database was created
   Created by	User who created the database
   [⋮] button	Modify or delete database

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

   Field	Description
   Status	Database status
   Type	Database type - Standard or Iceberg
   Connected catalog	Name of the catalog connected to the database
   ID	Database UUID
   Path	Path where the database is located
   Created at	Date the database was created

   
   

   Details

   You can view, create, and manage tables and database properties that belong to the database.

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.

   Field	Description
   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.