Quick BI supports user-created Snowflake data sources . If your business data is stored in a Snowflake database, you must add a Snowflake data source in Quick BI before you use Quick BI to process data. This topic describes how to add a user-created Snowflake data source in a group workspace. Only the Professional and Pro editions allow you to create a user-created Snowflake data source.
Prerequisites
Your network meets the following requirements:
If you Quick BI connect to the Snowflake database over the Internet, add the Quick BI IP address to the whitelist of the database. For more information, see Add security group rules.
If you want to connect Quick BI to your Snowflake database over an internal network, make sure that one of the following methods is used to ensure the connectivity between Quick BI and the user-created Snowflake data source:
If the Snowflake database is deployed on an Elastic Compute Service (ECS) instance, you can connect Quick BI to the Snowflake database over a virtual private cloud (VPC).
You can deploy a jump server and access the database over an SSH tunnel.
A user-created Snowflake database is created. The username and password that are used to access the Snowflake database are obtained.
The authentication AccessKey ID and AccessKey Secret are obtained. For more information, see Obtain an AccessKey.
Background information
Snowflake is a cloud native data warehousing service that uses the software-as-a-service (SaaS) model. Snowflake is suitable for cloud-based big data scenarios. Snowflake supports dynamic scaling to meet the performance requirements of enterprises.
Procedure
Log on to the Quick BI console.
Perform the steps that are shown in the following figure to add a user-created Snowflake data source.
Go to the Create Data Source page.
Click Show More.
Select the Snowflake data source.
In the Add Snowflake Data Source dialog box, configure the parameters.
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
The address where the Snowflake database is deployed, including the IP address or domain name.
Port Number
The corresponding port number of the database.
Instance
The name of the database to which you want to connect.
Schema
The schema of the database. Default value: PUBLIC.
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
If the Snowflake database is deployed on a ECS and is deployed in a VPC, select VPC Data Source and configure 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 pair.
Instance ID: the ID of the ECS instance.
Region: the region in which the ECS instance is deployed.
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: 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 is used to log on to the jump server.
SSH Port Number: the port number that is used to connect to the jump server. Default value: 22.
For more information, see Connect to a Linux instance by using a password.
Click Test Connection to verify that the data source can be connected.
After the data source passes the connectivity test, click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add data tables in the Snowflake database or user-created custom SQL statements to the Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.