Database

Available in VPC

When you subscribe to Data Catalog, the catalog and a default database are created automatically. A database is a set of tables storing metadata. In the Database menu, you can check the status of your catalog and create and manage databases.

Database list interface

Basic information for the Database list menu is as follows:

Database details interface

Basic information for the Database details menu is as follows:

Create a database

To create a database:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Database.
3. Click the [Create database] button.
4. When the Create database popup window appears, enter basic information for the database.
   • Name: Enter a database name.
     • As you cannot edit the database name, enter it with caution.
   • Description: Enter a description for the database.
   • Location: Select an Object Storage bucket where the database will be created.
     • Table locations inherit the database location you enter or select.
5. If needed, click the Tag settings area to add tags.
   • Click [Add], then enter tag information to add a tag.
     • For more information on data type, see Tag data types.
   • To delete a tag, select its check box and click [Delete].
   • Click the [Load tag template] button to display the popup window for loading tag templates.
     • Select and click a tag template, and then click the [Add] button to add a tag of the relevant tag template.
     • Click a template to preview its tags.
     • For more information on tag templates, see Tag Template.
6. Click [Create].

Search for and view database information

To search for databases and view their details:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Database.
3. In the search bar, enter a database name or a tag, then click the .
   • Enter tags in key:value format.
4. Click a database to view its information.
   • For field descriptions, see Database details.

Edit a database

To edit database information:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Database.
3. Click the name of the database you want to edit to open Database details.
4. To edit basic information, click [Edit] in Basic information.
   • Make your changes in the Edit database popup, and save.
   • For field descriptions, see Create a database.
   • Click the [Save] button.
5. To edit tags, click [Settings] in Tags.
   • Add or delete tag information in the Tag settings popup.
   • Click the [Save] button.

Delete a database

To delete a database you created:

1. In the VPC environment of the NAVER Cloud Platform console, navigate to > Services > Big Data & Analytics > Data Catalog.
2. Navigate to Database.
3. Click the name of the database you want to delete.
   • open Database details.
4. Click the [Delete] button.
5. When the confirmation popup appears, select a delete option, review the warnings, and click [Delete].
   • Delete all: Deletes the database and all its tables, and also deletes data at the database’s Object Storage location.
   • Delete database and tables only: Deletes the database and all its tables, but preserves the database’s Object Storage location.