All Products
Search
Document Center

ApsaraDB for ClickHouse:Connect to an ApsaraDB for ClickHouse cluster

Last Updated:Oct 24, 2023

ApsaraDB for ClickHouse allows you to use the command line tool of ClickHouse, Data Management (DMS), or other clients such as DataGrip or DBeaver to connect to an ApsaraDB for ClickHouse cluster. This topic describes how to use DMS to connect to an ApsaraDB for 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 databases and tables in ApsaraDB for ClickHouse online, and query data online. DMS can help you enhance data security, manage data more efficiently, and gain more value from your data.

Prerequisites

The following steps listed in Quick Start are complete:

Procedure

  1. Log on to the ApsaraDB for ClickHouse console.

  2. In the top navigation bar, select the region where the cluster is deployed.

  3. On the Default Instances tab of 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 as prompted.

    Parameter

    Description

    Example

    Database Type

    The type of the ApsaraDB for ClickHouse cluster. The default value is ClickHouse. You do not need to change this value.

    ClickHouse

    Instance Region

    The region for the ApsaraDB for ClickHouse cluster. The default value is the region where the current ApsaraDB for ClickHouse cluster is deployed. You do not need to change this value.

    Note

    If you want to log on to an ApsaraDB for ClickHouse cluster that is located in another region, select the region of the cluster from the drop-down list.

    China (Hangzhou)

    Instance ID

    The ID of the ApsaraDB for ClickHouse cluster. The default value is the ID of the current ApsaraDB for ClickHouse cluster. You do not need to change this value.

    Note

    If you want to log on to another ApsaraDB for ClickHouse cluster, select the ID of the cluster from the drop-down list.

    cc-bp16qwvp7hy8i****

    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

    If you select Remember password, you do not need to enter the account and the password next time you log on to the ApsaraDB for ClickHouse cluster.

    Select Remember password.

    Note
    • If you log on to the ApsaraDB for ClickHouse cluster by using DMS for the first time, the value of the Control Mode parameter is Flexible Management by default. After you log on to the cluster, you can change the control mode by modifying the information about the cluster. For more information, see Modify database instances and Control modes.

    • After the preceding parameters are set, click Test Connectivity in the lower-left corner of the Log on to Database Instance 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

If you want to connect to an ApsaraDB for ClickHouse cluster by using another method, see the following topics: