Snowflake
Connect & Ingest data from / to a Snowflake database
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 instancedatabase
(required) -> The database name of the instancepassword
(required) -> The password to access the instanceschema
(optional) -> The default schema to userole
(optional) -> The role to access the instancewarehouse
(optional) -> The warehouse to usepasscode
(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>
export SNOWFLAKE='snowflake://myuser:[email protected]/mydatabase?schema=<schema>&role=<role>'
Last modified 1mo ago