Database

Available in VPC

If you request subscription to Data Catalog, a catalog and built-in database are automatically created. A database is a set of tables, which stores metadata. The Database menu allows you to check the status of your catalog and create and manage databases.

Database screen

The following is the basic description of the Database menu for Data Catalog.

Area	Description
① Menu name	Menu name currently being checked, number of databases being checked
② Basic features	Functions displayed when entering the Database menu for the first time [Create database] button: click to create a database (see create database) [Learn more about products] button: click to go to the Data Catalog introduction page [Refresh] button: click to refresh the database lists
③ Catalog status	Display catalog status : hover over to see a description of each catalog status
④ Managing database	Managing database function [Edit] button: click to edit database settings (see edit database) [Delete] button: click to delete database (see delete database)
⑤ Search bar	Search database by database name or tags set in database
⑥ Database lists	List of databases being viewed, click to view detailed information
⑦ Information tab	Click each tab to see which tables or tags are set up in your database

Create database

The following describes how to create database.

1. From the NAVER Cloud Platform console, click the Services > Big Data & Analytics > Data Catalog menu, in that order.
2. Click the Database menu.
3. Click the [Create database] button.
4. When the create database pop-up window appears, enter the required information.
   • Name: enter database name
     • You cannot edit database name, so please enter it carefully.
   • Description: enter the description of database
   • Location: select the location where the database is created among Object Storage Buckets
     • Depending on the input/entered location information, the location value of the lower table is referenced.
5. If necessary, click the set tag area to add tags.
   • After clicking the [Add] button, enter the tag information in the input box to add the tag.
     • For more details on tag type, see tag data type.
   • You can delete a tag by clicking the check box of the tag to select it and then clicking the [Delete] button.
   • Click the [Load tag template] button to display the popup window for loading tag templates.
     • After selecting a tag template by clicking it, click the [Add] button to add a tag of the relevant tag template.
     • Click on a tag template to see the tags included in the tag template.
     • For more details about tag templates, see tag Template.
6. Click the [Create] button.

Search database and check information

The following describes how to view the created database and check the information.

1. From the NAVER Cloud Platform console, click the Services > Big Data & Analytics > Data Catalog menu, in that order.
2. Click the Database menu.
3. After entering the database name or description in the search box, click to search for the database.
4. Click the database to check the information.
   • For further information about the information items in a database, see create database.
   • [Table] tab: click to check the tables registered in the database
     • If no table registered in the database, you can move to the table creation screen by clicking the [Create table] button. For details about creating a table, see create table.
     • For more information on tables, see table.
   • [Tag] tab: click to check the tags registered in the database

Edit database

The following describes how to edit the created database.

1. From the NAVER Cloud Platform console, click the Services > Big Data & Analytics > Data Catalog menu, in that order.
2. Click the Database menu.
3. Click the database you want to edit and click the [Edit] button.
4. When the edit database popup window appears, edit the required information.
   • For further information about the information items in a database, see create database.
5. Click the [Save] button.

Delete database

The following shows how to delete the created database.

1. From the NAVER Cloud Platform console, click the Services > Big Data & Analytics > Data Catalog menu, in that order.
2. Click the Database menu.
3. Click the database you want to delete and click the [Delete] button.
4. When the notification popup window appears, check the cautions and click [Delete].