All Products
Search

This Product

    ApsaraDB for ClickHouse:Connect to ApsaraDB for ClickHouse using DMS

    Document Center

    ApsaraDB for ClickHouse:Connect to ApsaraDB for ClickHouse using DMS

    Last Updated:Aug 21, 2026

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

    Background information

    Data Management Service (DMS) is a graphical data management tool from Alibaba Cloud for managing relational and NoSQL databases. It supports features such as data management, SQL operations, data import and export, database cloning, performance optimization, and security audits. You can use DMS to manage, create, and run queries on your ApsaraDB for ClickHouse databases and tables. This makes your data more secure, your management more efficient, and the value of your data more evident.

    Precautions

    When you create an ApsaraDB for ClickHouse cluster, the system automatically adds the DMS server IP addresses to the ApsaraDB for ClickHouse whitelist. If this process fails, you must add the IP addresses manually. For a list of DMS IP address ranges by region, see DMS IP address ranges.

    Procedure

    1. Log on to the ApsaraDB for ClickHouse console with your Alibaba Cloud account.

    2. In the upper-left corner of the page, select your cluster's region.

    3. On the Clusters page, select Instance list as the cluster type, and then click the target cluster's ID.

    4. On the Cluster Information page, click Log On to Database in the upper-right corner.

    5. Configure the following parameters.

      Parameter

      Description

      The database type

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

      Region

      The default is the region of the current ApsaraDB for ClickHouse cluster. You do not need to change it.

      Note

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

      Instance ID

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

      Note

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

      Database Account

      The username for logging in to the database.

      Database Password

      The password for the database account.

      Remember password

      Select Remember password to save your credentials. This automatically logs you in the next time you connect to this ApsaraDB for ClickHouse cluster.
      Note

      • When you log in to an ApsaraDB for ClickHouse cluster using DMS for the first time, DMS sets the Control Mode to Flexible Management by default. After you log in, you can change the control mode by editing the instance. For more information, see Edit instance information and Control modes.

      • After configuring the login parameters, you can click Test Connection in the lower-left corner. If the connectivity test fails, refer to the error message to verify the information you entered.

    6. Click Log On.

    7. In the SQL Console, enter an SQL statement.

    8. Click Execute(F8) on the menu bar and view the results.

      This example shows how to create a local table.建立本地表

    DMS supports various SQL statements and provides a visual interface for inserting, updating, deleting, and querying data. For more information, see SQL Console.