Add a Snowflake data source to establish a connection between Quick BI and Snowflake. If your business data is stored in Snowflake, you must add a Snowflake data source to analyze data in Quick BI. This topic describes how to add a user-created Snowflake data source. This feature is available only for group workspaces in Quick BI Pro and Quick BI Enterprise.
Prerequisites
Ensure that your network connection is properly configured:
If you connect to your Snowflake database from Quick BI over the public network, add Quick BI's IP addresses to your database whitelist. For more information, see Use security groups.
If you connect to your Snowflake database from Quick BI over a private network, ensure connectivity by using one of the following methods:
If your Snowflake database is hosted on an Alibaba Cloud ECS instance, you can connect to it through a VPC.
You can also set up a bastion host and use an SSH tunnel to access the database.
The username and password for your Snowflake database.
You have obtained an AccessKey ID and an AccessKey Secret for authentication. For more information, see Obtain an AccessKey.
Background information
Snowflake is a cloud-native Software as a Service (SaaS) platform for data warehousing, designed for big data workloads in the cloud. It scales dynamically to provide the performance required for enterprise applications. For more information, visit https://www.snowflake.com/.
Procedure
Log on to the Quick BI console.
Follow these steps to add the data source.
Navigate to the data source creation page. For instructions, see Access the data source creation page.
On the User-Created Data Source tab, select Snowflake.
In the Configure Connection dialog box, configure the parameters based on your business requirements.
Parameter
Description
Display Name
The name for the data source, which appears in the data source list.
The name cannot contain special characters or leading or trailing spaces.
Database Address
The address of the Snowflake database. You can use an IP address or a domain name.
Port
The port number of the database.
Database
The name of the database to connect to.
Schema
The name of the schema to connect to. The default value is PUBLIC.
Username
The username for the Snowflake database account.
Password
The password for the specified username.
VPC Data Source
Select VPC Data Source and configure the following parameters only if your Snowflake database is deployed on an Alibaba Cloud ECS instance and uses a VPC network.
Purchaser AccessKey ID: The AccessKey ID of the account that purchased the instance.
For more information, see Obtain an AccessKey.
NoteEnsure that this AccessKey ID has read permissions on the target instance. If it also has write permissions for the associated security group, the system automatically adds the required IP addresses to the database whitelist. Otherwise, you must add them manually. For more information, see Create a custom permission policy.
Purchaser AccessKey Secret: The AccessKey Secret of the account that purchased the instance.
For more information, see Obtain an AccessKey.
Instance ID: The ID of the ECS instance. You can obtain the instance ID from the Instances page in the ECS console.
For more information, see View instance information.
Region: The region where the ECS instance is located.
For more information, see View instance information.
SSH
If you select SSH, configure the following parameters:
This method uses an SSH tunnel through a bastion host to access the database. Obtain the required bastion host information from your operations and maintenance (O&M) team or system administrator.
SSH Host: The IP address of the bastion host.
SSH Username: The username for logging on to the bastion host.
SSH Password: The password for the specified SSH username.
SSH Port: The port of the bastion host. The default value is 22.
For more information, see Connect to a Linux instance by using an SSH client.
Click Connection Test to verify the connection.
After the test succeeds, click OK to add the data source.
Next steps
After you add the data source, you can create a dataset and analyze your data.
Add tables or custom SQL queries from your Snowflake database to Quick BI. For more information, see Create a dataset.
Create dashboards and add charts to visualize and analyze your data. For more information, see Create a dashboard and Overview of charts.
Drill down into the data for more detailed analysis. For more information, see Step 3: Configure and display drill down.