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
PostgreSQL	Data from a PostgreSQL database

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 or PostgreSQL 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 or PostgreSQL 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].

   Item	Category	Required	Description
   Basic information	Data source name	Yes	Enter name for the data source
   	Description	No	Description of the data source
   Details	Data source type	Yes	MySQL, PostgreSQL
   	Instance group	Yes	Select instance group
   	Database name	Yes (*If PostgreSQL is selected)	Enter database name
   Connection info	ID	Yes	Connection ID
   	Password	Yes	Connection password
   [Test connection] button		Yes	Test connection ⚠️ Must complete successfully to create the data source
   Visibility	Public	Yes (If Private not selected)	Visible to entire project / default setting
   	Private	Yes (If Public not selected)	Visible only to me

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 or PostgreSQL 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].