Quick BI:Add an user-created Impala Data Source

Procedure

1. Log on to the Quick BI console.

2. Follow the steps depicted below to add a data source.

   1. Navigate to the data source creation page via the data source creation entry.

   2. Click Show more.

   3. Select the Snowflake data source.

3. In the Add Snowflake Data Source dialog box, configure the settings as per your business requirements.

   Name	Description
   Display Name	The display name in the datasource config list. The name cannot contain special characters or start or end with spaces.
   Database Address	The address where the Snowflake database is deployed, including the IP address or domain name.
   Port	The corresponding port number of the database.
   Database	The name of the database to be connected.
   Schema	The schema of the database. The default value is PUBLIC.
   Username	The username that is used to log on to the Snowflake database.
   Password	The password that is used to log on to the Snowflake database.
   VPC Data Source	Select VPC Data Source and configure the following parameters only if the Snowflake database is deployed on an Alibaba Cloud ECS instance and uses the Alibaba Cloud VPC network. Purchaser Accessid: The AccessKey ID of the purchaser of this instance. For more information, see Obtain an AccessKey. Note Ensure that the AccessKey ID has the Read permission on the destination instance. In addition, if you have the Write permission on the corresponding security group, the system automatically adds the whitelist. Otherwise, you must manually add it. For more information about related operations, see Create a custom policy. Purchaser Accesskey: The AccessKey Secret of the purchaser of this instance. For more information, see Obtain an AccessKey. Instance ID: The ID of the ECS instance. Log on to the ECS console and obtain the instance ID on the Instances tab. For more information, see View instance information. Area: The area where the ECS instance is located. For more information, see View instance information.
   SSH	If you select SSH, you must configure the following parameters: You can deploy a jump server and access the database over an SSH tunnel. To obtain the jump server information, contact O&M personnel or system administrators. SSH Host: Enter the IP address of the jump server. SSH Username: The username that is used to log on to the jump server. SSH Password: The password that corresponds to the username that is used to log on to the jump server. SSH Port: The port of the jump server. The default value is 22. For more information, see Log on to a Linux instance by using password authentication.

4. Click Connection Test to verify the data source connectivity.

   

5. Once the test is successful, click OK to finalize the data source addition.