Connect using DMS - ApsaraDB for ClickHouse - Alibaba Cloud Documentation Center

This topic describes how to use Data Management Service (DMS) to connect to an ApsaraDB for ClickHouse cluster and manage data online.

Background information

DMS is a graphical data management tool from Alibaba Cloud for managing relational databases and NoSQL databases. It supports features such as data management, SQL operations, and data solutions such as data import and export, database cloning, performance optimization, and security audits. You can use DMS to easily manage your databases, create databases and tables for ApsaraDB for ClickHouse, and run online data queries. This helps improve data security and management efficiency, and makes the value of your data more apparent.

Notes

When you create a new ApsaraDB for ClickHouse cluster, the system automatically adds the IP addresses of DMS servers to the whitelist of the ApsaraDB for ClickHouse cluster. If the automatic addition fails, you must add the IP addresses manually. For a list of the IP addresses of DMS servers in different regions, see DMS IP address ranges.

Procedure

Log on to the ApsaraDB for ClickHouse console using your Alibaba Cloud account.
In the upper-left corner of the page, select the region where your cluster is located.
On the Cluster List page, select the Instance List tab that corresponds to your cluster type. Then, click the ID of the destination cluster.
On the Cluster Information page, click Log On to Database in the upper-right corner.

Configure the following parameters.

Parameter	Description
Database type	Defaults to ClickHouse, which is the type of the ApsaraDB for ClickHouse cluster. No change is required.
Instance region	Defaults to the region of the current ApsaraDB for ClickHouse cluster. No change is required. Note To log on to an ApsaraDB for ClickHouse cluster in a different region, select the destination region from the drop-down list.
Instance ID	Defaults to the ID of the current ApsaraDB for ClickHouse cluster. No change is required. Note To log on to a different ApsaraDB for ClickHouse cluster, select the destination cluster ID from the drop-down list.
Database account	The logon account for the database.
Database password	The password for the database account.
Remember password	Check Remember password to automatically log on to this ApsaraDB for ClickHouse cluster in the future without re-entering your credentials.

Note

The first time you use DMS to log on to an ApsaraDB for ClickHouse cluster, the control mode defaults to Flexible Management. After you log on, you can change the control mode by editing the instance. For more information, see Edit an instance and Control modes.
After you configure the logon parameters, you can click Test Connection in the lower-left corner. If the connection test fails, check the cluster information that you entered based on the error message.

Click Log On.
In the SQL Console window, enter the SQL statement that you want to execute.
In the menu bar, click Execute (F8) and view the results.
The following example shows how to create a local table.

DMS supports various SQL statements. It also provides a visual interface for create, read, update, and delete (CRUD) operations on the destination database. For more information, see Introduction to the SQL window.