datadict-connector-snowflake 0.0.3

Snowflake connector for DataDict

DataDict Snowflake Connector

The Snowflake connector synchronizes the database, schemas, tables, views, and columns visible to a Snowflake role into DataDict's standard SQL catalog layout. View dependencies are extracted on a best-effort basis from GET_DDL output.

name: warehouse
type: snowflake
connection:
  profile: snowflake_test

snowflake_test:
  account: my-organization-my-account
  user: DATADICT_USER
  password: ${SNOWFLAKE_PASSWORD}
  role: DATADICT_ROLE
  warehouse: COMPUTE_WH
  database: ANALYTICS
  schema: PUBLIC

account, user, password, warehouse, and database are required. role, schema, and host are optional. The schema controls the session default; synchronization includes every non-system schema in the configured database that is visible to the role.

The default test suite replays result-level cassettes and does not contact Snowflake. Run the live tests with credentials from the repository-root .env file:

task test:live

Refresh the safe, result-only cassette after intentionally changing the test objects:

poetry run python scripts/record_snowflake_cassette.py