Quick BI is a self-service business intelligence (BI) platform that is tailored for cloud users and enterprises. It provides a graphical user interface (GUI) and supports flexible and efficient multidimensional analysis. Quick BI helps you gain precision data-driven insights into your business. You can add your ApsaraDB for ClickHouse cluster as a data source in Quick BI and then build a BI system for your ApsaraDB for ClickHouse cluster.

Prerequisites

  • Quick BI Pro or Quick BI Enterprise Standard is activated. You can also apply for a Quick BI free trial.
  • An ApsaraDB for ClickHouse cluster is created.
    Note To allow Quick BI to connect to your ApsaraDB for ClickHouse cluster, add the following Classless Inter-Domain Routing (CIDR) blocks to the whitelist of your cluster: 10.152.69.0/24, 10.152.163.0/24, and 139.224.4.0/24.

Add your ApsaraDB for ClickHouse cluster as a data source in Quick BI

  1. Log on to the Quick BI console.
  2. In the upper-right corner, turn on the Development mode.
    17748601
  3. Click the Workspace tab. In the left-side navigation pane, select Default Workspace from the drop-down list.
    17748602
  4. In the left-side navigation pane, click Data Sources.
  5. On the Data Sources page, click Create Data Source in the upper-right corner. You can also click Retrieve Data in the Cloud Data Sources card.
    17748603
  6. In the Add Data Source dialog box, click the Cloud Data Sources tab and then the ClickHouse card.
    17748605
  7. In the Add ClickHouse Database dialog box, set the parameters.
    17748604
    Parameter Description
    Name The name of the data source.
    Database Address The public endpoint of the ApsaraDB for ClickHouse cluster that you want to add as a data source. Do not set this parameter to a Virtual Private Cloud (VPC) endpoint.
    Port Number The port number of the ApsaraDB for ClickHouse cluster that you want to add as a data source.
    Database The name of the ApsaraDB for ClickHouse cluster that you want to add as a data source.
    Username The username that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
    Password The password that you use to connect to a database in the ApsaraDB for ClickHouse cluster.
  8. Click Test Connection to test connectivity with the database. After the database passes the connectivity test, click OK.