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 to 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.