This topic describes how to manage data of an ApsaraDB for ClickHouse cluster in the Data Management (DMS) console.

DMS is an online database management service that is provided by Alibaba Cloud. You can create databases and tables for your ApsaraDB for ClickHouse cluster and query data of the cluster in the DMS console. To manage data of an ApsaraDB for ClickHouse cluster in the DMS console, perform the following steps:

  • Step 1: Go to the DMS console.
On the Clusters page of the ApsaraDB for ClickHouse console, click the ID of the cluster that you want to manage to go to the cluster details page. On the cluster details page, click Log On to Database in the upper-right corner to go to the DMS console.
  • Step 2: Log on to the ApsaraDB for ClickHouse cluster.

In the Login instance dialog box of the DMS console, configure the required information, including the region, cluster ID, database account, and password. Then, click Test connection in the lower-left corner of the dialog box. If the connection test succeeds, click Login. If the connection test fails, modify the configurations and test again.

  • Step 3: Manage and query data of the ApsaraDB for ClickHouse cluster in the DMS console.

In the left-side navigation pane of the DMS console, double-click a database in the ApsaraDB ClickHouse cluster to go to the SQLConsole. Enter an SQL statement and click Execute at the top of the SQLConsole. View the results on the Execution History tab. Data definition language (DDL) and data manipulation language (DML) statements are supported. For more information about supported queries, see SQL Console.