This topic describes how to add an ApsaraDB for ClickHouse data source. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add ApsaraDB for ClickHouse data sources.

Prerequisites

An ApsaraDB for ClickHouse cluster is created. For more information, see Create a cluster.
Note Add the following CIDR blocks of Quick BI to the whitelist of the ApsaraDB for ClickHouse cluster to allow Quick BI to connect to the ApsaraDB for ClickHouse cluster:

10.152.69.0/24, 10.152.163.0/24, and 139.224.4.0/24.

Procedure

  1. Choose Workspace > Data Sources.
  2. In the upper-right corner of the Data Sources page, click Create Data Source.
  3. In the Add Data Source dialog box, click the Cloud Data Sources tab. Then, click the ClickHouse card.
    clickhouse_intl
  4. In the Add ClickHouse Database dialog box, configure the parameters.
    3.12.1
    • If you use the Internet to connect Quick BI to the data source, configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The public endpoint of the ApsaraDB for ClickHouse cluster.
      Port Number The port number that is used to connect to the ApsaraDB for ClickHouse cluster. Default value: 8123.
      Database The name of a database in the ApsaraDB for ClickHouse cluster.
      Username The username that is used to connect to the database.
      Password The password that is used to connect to the database.
    • If you use a virtual private cloud (VPC) to connect Quick BI to the data source, select VPC Data Source and configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The private endpoint of the database.
      Port Number The port number that is used to connect to the database over the VPC.
      Database The custom name of the database. The name is specified when you create the database. For example, enter ClickHouse.
      Username The username that is used to log on to the database.
      Password The password that is used to log on to the database.
      VPC Data Source Select VPC Data Source and configure the following parameters:
      • AccessKey ID: the AccessKey ID that you used to purchase the ApsaraDB for ClickHouse cluster. For more information, see Obtain an AccessKey pair.
      • AccessKey Secret: the AccessKey secret that you used to purchase the ApsaraDB for ClickHouse cluster. For more information, see Obtain an AccessKey pair.
      • Instance ID: the ID of the ApsaraDB for ClickHouse cluster.
      • Region: the region in which the ApsaraDB for ClickHouse cluster is deployed.
  5. Click Test Connection to verify that the data source can be connected.
    3.12.1
  6. Click OK.

What to do next

After you add a data source, you can create a dataset and analyze data.
  • You can add data tables in the ApsaraDB for ClickHouse data source or user-defined SQL statements for ad hoc analysis to Quick BI. For more information, see Create a dataset.
  • For more information about how to add visual charts and analyze data, see Create a dashboard and Overview.
  • For more information about how to mine data value and deeply analyze data, see Configure the drilling feature.