Snowflake

:::info Required extra This connection requires the snowflake extra. See Installation. :::

Test data in Snowflake.

Server

servers:
  - server: snowflake
    type: snowflake
    account: abcdefg-xn12345
    database: ORDER_DB
    schema: ORDERS_PII_V2

account, database, and schema come from the servers section above.

Environment variables

Any DATACONTRACT_SNOWFLAKE_-prefixed variable is passed (lowercased, prefix stripped) as a connection parameter to the snowflake-connector-python driver. Set the variables required by your workspace's authenticator mode.

Connection parameter	Environment variable
username	DATACONTRACT_SNOWFLAKE_USERNAME
password	DATACONTRACT_SNOWFLAKE_PASSWORD
warehouse	DATACONTRACT_SNOWFLAKE_WAREHOUSE
role	DATACONTRACT_SNOWFLAKE_ROLE
connection_timeout	DATACONTRACT_SNOWFLAKE_CONNECTION_TIMEOUT
authenticator	DATACONTRACT_SNOWFLAKE_AUTHENTICATOR
private_key	DATACONTRACT_SNOWFLAKE_PRIVATE_KEY
private_key_passphrase	DATACONTRACT_SNOWFLAKE_PRIVATE_KEY_PASSPHRASE
private_key_path	DATACONTRACT_SNOWFLAKE_PRIVATE_KEY_PATH