Quick BI:Alibaba Cloud Data Source ClickHouse

Limits

• Only workspace administrators and developers can add data sources.

• Only ApsaraDB for ClickHouse Professional Edition and ApsaraDB for ClickHouse Pro Edition allow you to add a ClickHouse data source.

• Supports 20.3 and 22.8 versions.

Procedure

1. Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.

   Before you connect to the ApsaraDB for ClickHouse cluster, you must add the Quick BI IP address Quick BI the IP address to the whitelist of the ApsaraDB for ClickHouse cluster. For more information about how to add an Alibaba Cloud ClickHouse whitelist, see Configure a whitelist.

2. Add a Hologres data source and verify that the data source can be connected.

   1. After you log on to the Quick BI console.

   2. Perform the steps that are shown in the following figure to add an ApsaraDB for ClickHouse data source.

      1. Go to the Create Data Source page.

      2. Select ClickHouse Data Source.

         

      3. Select Alibaba Cloud for Data Source Type.

         

3. In the Configure Connection dialog box, configure the following settings based on your business requirements.

   Feature	Description
   Name	The name of the data source. The name is displayed in the data source list. The name cannot contain special characters or start or end with spaces.
   Database Address and Port Number	The public endpoint of the ApsaraDB for ClickHouse database. If you use a VPC data source, you must enter the internal endpoint and port of the ApsaraDB for ClickHouse database. Log on to the ApsaraDB ClickHouse console and obtain the database address in the Network Information section. Example: cc-xxxxxxxxxxxxxxxxxx.ads.rds.aliyuncs.com.
   Instance	The custom name of the database. The name is specified when you create the database.
   Username and Password	The username and password that are used to access the database.
   Time zone	The time zone where the ClickHouse database is deployed.
   SSL	If SSL is configured for the destination data source, you can select SSL to protect data security.
   VPC Data Source	Select VPC Data Source and set the following parameters: AccessKey ID: the AccessKey ID that is used to purchase the instance. For more information, see Obtain an AccessKey pair. AccessKey: the AccessKey secret that is used to purchase the instance. For more information, see Obtain an AccessKey. Instance ID: the ID of the ClickHouse database. Region: the region in which the ClickHouse cluster is deployed.
   Initialize SQL statements	The SQL statement that is initialized and executed after each data source connection. Only SET statements are allowed. The statements are separated by semicolons.
   Enable the file upload portal	You can upload files after you enable this function.

4. Click Test Connection to verify that the data source can be connected.

   

5. After the database passes the connectivity test, click OK.