Preparations for data source

Available in VPC

Before starting to use the Data Query service, this section describes how to subscribe to integrated services and prepare data for queries.

Subscribe to integrated service

The Data Query service retrieves and analyzes data through integration with other services.
It supports integration with Data Catalog and Object Storage services of NAVER Cloud Platform, serving respectively as the source and target data nodes.
Thus, a subscription for using these services must be completed before using the Data Query service.

Prepare data source

The Data Catalog service, which acts as the source data node, must have data registered for query use. If data is not yet registered, follow the guidance below to register it.

Note

For detailed instructions on the Data Catalog service, see the Data Catalog service user guide.
Data Catalog service fees necessary for using the Data Query service are charged separately.

1. Check source data location

If the source data is not registered in the Data Catalog service, you must create a connection with the object storage or database server and register the data in the Data Catalog service.
First, identify the location where the source data is stored.

If using the Object Storage service, understand the bucket and detailed directory information where the data is stored.
If using the Cloud DB service, identify the DB server name and database name.

2. Create database

Create a new database in the Data Catalog service.

The database name is also displayed when you specify a data source in the Data Query service, so use a name that is clearly distinguishable from other databases.

For more information on how to create a database, see Create database.

3. Create connection

The connection registered in the Data Catalog service is a mandatory item to specify when adding a data source for queries. If there is no connection created for the source data, be sure to create one.
For more information on how to create a connection, see Create connection.

4. Create table

In the Data Catalog service, collect data and create tables.

Tables can be automatically created through a scanner or manually by defining a schema.
The Data Query service imports the internal structure of the data source up to the table level and displays it in a tree format. Ensure that tables are created without errors to use the service properly.

For more information on how to create a table, see Create table.