Updated on 2023-06-02 GMT+08:00

Creating ClickHouse Data Connections

  1. Log in to the DLV console.
  2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.

    Figure 1 Creating a data connection

  3. In the New Data Connection dialog box, set Data Source Type to MRS ClickHouse and set the related parameters.

    Figure 2 Creating a ClickHouse data connection

    To connect to ClickHouse, configure the parameters as described in Table 1.

    Table 1 ClickHouse data connection parameters

    Parameter

    Description

    Name

    Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).

    Cluster ID

    ID of the MRS cluster.

    Host

    After an MRS cluster is selected, the preferred private IP address of the cluster will be automatically matched. The domain name cannot be changed.

    Agent

    Select an available connection agent, such as VPC connection, CDM proxy, or Internet.

    Database

    You can select a database from the Database drop-down list.

  4. Click OK.

Using MRS ClickHouse Data Sources

You can configure and use MRS ClickHouse data sources by referring to the instructions in Using DWS Data Sources.