Snowflake

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

SQL Server

Next - Connections

Storage Connections

Last modified 1mo ago