ApsaraDB ClickHouse allows you to use the command line tool of ClickHouse, Data Management (DMS), or other client such as DataGrip or DBeaver to connect to an ApsaraDB ClickHouse cluster. This topic describes how to use DMS to connect to an ApsaraDB ClickHouse cluster.

Background information

DMS is a graphical data management tool provided by Alibaba Cloud. You can use DMS to manage relational databases and NoSQL databases. DMS provides features such as data management, SQL operations, data import and export, database cloning, database performance optimization, and security audit. You can use DMS to simplify database management, create ApsaraDB ClickHouse databases and tables online, and query data online. DMS can help you secure data, manage data more efficiently, and gain more value from your data.

Prerequisites

The following steps listed in Quick Start are complete:
  • Create a cluster
  • Create an account
  • Configure a whitelist
    Note When you create an ApsaraDB ClickHouse cluster, the system automatically adds a whitelist named dms for the ApsaraDB ClickHouse cluster and adds the IP addresses of DMS servers to the whitelist. If the whitelist fails to be added, you must manually add the whitelist. For more information about the IP addresses of DMS servers in different regions, see DMS IP addresses and CIDR blocks.

Procedure

  1. Log on to the ApsaraDB for ClickHouse console.
  2. In the upper-left corner of the page, select the region where the cluster is deployed.
  3. On the Clusters page, click the ID of the cluster that you want to manage.
  4. On the Cluster Information page, click Log On to Database.
  5. Set the following parameters based on the on-screen instructions that are displayed.
    Parameter Description Example
    Database type The type of the ApsaraDB ClickHouse cluster. The default value is ClickHouse. You do not need to change this value. ClickHouse
    Instance Area The default value is the region where the current ApsaraDB ClickHouse cluster is deployed. You do not need to change this value.
    Note If you want to log on to an ApsaraDB ClickHouse cluster that is located in another region, select the region of the cluster from the drop-down list.
    China (Hangzhou)
    Instance ID The default value is the ID of the current ApsaraDB ClickHouse cluster. You do not need to change this value.
    Note If you want to log on to another ApsaraDB ClickHouse cluster, select the ID of the cluster from the drop-down list.
    cc-bp16qwvp7hy8i****(test)
    Database account The account that is used to log on to the database. test
    Database password The password of the database account. 123456Aa
    Remember password After you select Remember password, you do not need to enter the account and the password again when you log on to the ApsaraDB ClickHouse cluster. Select Remember password.
    Note
    • The first time you log on to the ApsaraDB ClickHouse cluster by using DMS, the control mode is Flexible Management by default. You can change the control mode by editing the cluster features after you log on to the cluster. For more information, see Modify database instances and Control modes.
    • After the preceding parameters are configured, click Test connection in the lower-left corner of the dialog box. If the connectivity test fails, check the parameter values that you specify based on the error message.
  6. Click Login.

What to do next

Create a database

References

You can also connect to an ApsaraDB ClickHouse cluster by using other methods. For more information, see the following topics: