Connect & Ingest data from / to a Snowflake database

Sling CLI Setup

The following credentials keys are accepted:
  • host (required) -> The hostname or account the instance (eg.
  • 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. We must provide the type=snowflake property:
$ sling conns set SNOWFLAKE type=snowflake host=<host> user=<user> database=<database> password=<password> role=<role>
# Or use url
$ sling conns set SNOWFLAKE url=snowflake://myuser:[email protected]/mydatabase?schema=<schema>&role=<role>

Environment Variable

export SNOWFLAKE='snowflake://myuser:[email protected]/mydatabase?schema=<schema>&role=<role>'
If you are facing issues connecting, please reach out to us at [email protected].