Manage data source

How to add and manage data sources for queries.

Data source types

Data source types supported by Data Query:

Type	Description
Data Catalog	Data stored in a Data Catalog catalog - View Data Catalog
MySQL	Data from MySQL databases

info

1. Data Catalog > Catalog is automatically linked without creating a separate data source.
   • You must use the Data Catalog service and have a catalog created beforehand. (View Data Catalog service)
2. MySQL type requires data source creation to fetch data.
   • You must use the MySQL service and have an instance group created in advance.
3. Project members can view and use all data sources linked to the project when executing queries.

Create data source

To connect to a MySQL data source, create a new data source as follows:

1. Go to KakaoCloud Console > Analytics > Data Query menu.

2. In the data source management menu, select [Create data source].

3. In the Create data source pop-up, enter the required information and select [Create].

   Field	Category	Required	Description
   Basic info	Data source name	Required	Enter data source name
   	Description	Optional	Description of the data source
   Details	Data source type	Required	MySQL (*Only MySQL is supported currently)
   	Instance group	Required	Select MySQL instance group
   Connection info	ID	Required	Connection ID
   	Password	Required	Connection password
   [Test connection] button		Required	Test MySQL connection ⚠️ You must successfully complete the connection test to create the data source.
   Visibility	Public	Required (if Private not selected)	Public to entire project / Default setting
   	Private	Required (if Public not selected)	Visible to self only

caution

After requesting data source creation, it may take some time before it appears in the data source list due to network or server processing delays.

Manage data source

How to manage MySQL data source information:

info

In Data Query, you cannot modify or delete data sources of type DATA_CATALOG.
To manage such sources, use the Data Catalog service.

Edit data source info

You can edit the description of a data source.

1. Go to KakaoCloud Console > Analytics > Data Query menu.
2. In the data source management menu, select the data source and select [Edit].
3. Update the description and select [Edit].

Delete data source info

You can delete unused data source connections to disconnect them.

caution

Once a MySQL data source is deleted, it will no longer be available in the query editor.

1. Go to KakaoCloud Console > Analytics > Data Query menu.
2. In the data source management menu, select the MySQL data source to disconnect and select [Delete].