Snowflake

The Snowflake driver depends on the sqlalchemy snowflake and can be installed with:

pip install "sayn[snowflake]"

SAYN will consider the following parameters to construct the sqlalchemy url:

Parameter	Description	Default
account	account.region	Required
user	User name used to connect	Required
password	Password for that user	Required
database	Database in use upon connection	Required
role	User role to use on this connection	Default role for user
warehouse	Warehouse to use to run queries	Default warehouse for user
schema	Default schema for the connection

Other parameters specified will be passed on to sqlalchemy.create_engine when creating the engine.

settings.yaml

credentials:
  snowflake-conn:
    type: snowflake
    account: xy12345.us-east-1
    user: snowflake_user
    role: etl
    password: 'Pas$w0rd' #use quotes to avoid conflict with special characters
    database: models
    warehouse: etl-warehouse

Check the sqlalchemy snowflake dialect for extra parameters.