Snowflake

Connect to a Snowflake database

Setup

The following credentials keys are accepted:

• host (required) -> The hostname or account the instance (eg. pua90768.us-east-11)

• user (required) -> The username to access the instance

• database (required) -> The database name of the instance

• password (required) -> The password to access the instance

• schema (optional) -> The default schema to use

• role (optional) -> The role to access the instance

• warehouse (optional) -> The warehouse to use

• passcode (optional) -> Specifies the passcode provided by Duo when using multi-factor authentication (MFA) for login.

• authenticator (optional) -> Specifies the authenticator to use to login.

Here is an example of setting a connection named SNOWFLAKE:

# YAML format
export SNOWFLAKE="{type: snowflake, host: <host>, user: <user>, database: <database>, password: <password>, port: <port>, schema: <schema>, role: <role>}"

# URL format
export SNOWFLAKE="snowflake://myuser:[e-mail]/mydatabase?schema=<schema>&role=<role>"