Create a Snowflake Connection

White Label Data allows you to use Snowflake as a data warehouse and to map query results to native White Label Data visualizations. In order to use Snowflake, you must first set up a connection in White Label Data. You must create or use a Snowflake user account that has access to the tables you plan to use. In addition, you must white list the IP address for your development environment and the production server.

Example appconfig.json:

 "connections" : [
        {
            "type" : "snowflake",
            "username" : "jsmith",
            "account" : "xx12345.us-east-1",
            "warehouse" : "MY_WAREHOUSE",
            "database" : "MY_DATABASE",
            "schema" : "PUBLIC",
            "env_var" : "SNOWFLAKE_PASSWORD"
        }
    ]
Option Example Description
username "jsmith" Snowflake username.
account "xx12345.us-east-1" Snowflake account name that includes the region.
warehouse "MY_WAREHOUSE" Name of the Snowflake warehouse to use for the connection.
database "MY_DATABASE" Name of the default Snowflake database to use for the connection.
schema "PUBLIC" Name of the Snowflake schema for the connection.
env_var "SNOWFLAKE_PASSWORD" Name of environment variable that will hold the Snowflake password.

Note: You must also add this environment variable to your environment settings for your instance. See “Adding connection environment variables to your local development environment” here.