Quick BI supports self-managed 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 self-managed Snowflake data source. Only Quick BI Enterprise Standard and Quick BI Pro allow you to add self-managed Snowflake data sources to group workspaces.

Prerequisites

  • Make sure that your network meets the following requirements:
    • If you use the Internet to connect Quick BI to your Snowflake database, make sure that the CIDR blocks of Quick BI are added to the whitelist of the Snowflake database. For more information, see Add security group rules.

      The CIDR blocks of Quick BI are 10.152.69.0/24, 10.152.163.0/24, and 139.224.4.0/24.

    • If you use an internal network to connect Quick BI to the Snowflake database, make sure that one of the following methods is used to ensure the connectivity between Quick BI and the self-managed 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 connect to the database over an SSH tunnel.
  • A self-managed Snowflake database is created. The username and password that are used to connect to the Snowflake database are obtained.
  • The AccessKey ID and AccessKey secret that are used for authentication are obtained. For more information, see Obtain an AccessKey pair.

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. For more information, visit https://www.snowflake.com/.

Limits

Only workspace administrators and organization administrators can add data sources.

Procedure

  1. Add a data source, as shown in the following figure.
    Add a data source
  2. In the Add Snowflake Database dialog box, configure the following parameters.
    • If you use the Internet to connect Quick BI to the Snowflake database, configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The public IP address of the server on which the Snowflake database is deployed.
      Port Number The port number that is used to connect to the database over the Internet. Default value: 433.
      Database The custom name of the database. The name is specified when you create the database. For example, enter Snowflake.
      Schema The name of the database to connect. 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.
    • If you use an internal network to connect Quick BI to the Snowflake database, select User-created ECS Data Source (VPC) and configure the following parameters.
      Parameter Description
      Name The name of the data source. The name appears in the list of data sources.

      The name can contain letters, digits, underscores (_), and hyphens (-).

      Database Address The private endpoint of the ECS instance on which the database is deployed.
      Port Number The port number that is used to connect to the database over the internal network. Default value: 433.
      Database The custom name of the database. The name is specified when you create the database. For example, enter Snowflake.
      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.
      User-created ECS Data Source (VPC) Select User-created ECS Data Source (VPC) only when the Snowflake database is deployed on an ECS instance and is connected to Quick BI over a VPC. After you select User-created ECS Data Source (VPC), configure the following parameters:
      • AccessKey ID: the AccessKey ID that you used to purchase the instance on which the database is deployed.

        For more information, see Obtain an AccessKey pair.

      • AccessKey Secret: the AccessKey secret that you used to purchase the instance.

        For more information, see Obtain an AccessKey pair.

      • Instance ID: the ID of the instance on which the Snowflake database is deployed.
      • Region: the region in which the instance that runs the Snowflake database is deployed.
    To use an SSH tunnel to connect to a self-managed data source, select ssh and configure the following parameters.
    Parameter Description
    ssh If you select ssh, configure the following parameters:
    You can deploy a jump server and connect to 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.
    Note Only Quick BI Enterprise Standard allows you to connect to self-managed data sources in group workspaces over SSH tunnels.
  3. Click Test Connection to verify that the data source can be connected.
    Data test
  4. Click OK.

What to do next

After you add a data source, you can create a dataset and analyze data.
  • You can add data tables in the self-managed Snowflake data source or user-defined SQL statements for ad hoc analysis to Quick BI. For more information, see Create a dataset.
  • For more information about how to add visual charts and analyze data, see Create a dashboard and Overview.
  • For more information about how to mine data value and deeply analyze data, see Configure the drilling feature.