Snowflake

Snowflake SQL connector using the official Python connector and sqlglot.

Property	Value
Key	snowflake
Source type	warehouse
Status	native
Active by default	no
Default cache strategy	deterministic_first
Capabilities	supports_cost_metadata, supports_discovery, supports_field_permissions, supports_ingestion, supports_query, supports_write

Caution

No test stack registers a source on this connector, so its source roles, policy, redaction and audit are not exercised by any test. The adapter works; its governance is unproven.

Connection configuration

Secret fields should be given as a reference, <field>_ref, such as env://NAME, rather than a literal.

Key	Secret
account	no
user	no
password	no
password_ref	no
private_key	no
private_key_ref	no
warehouse	no
database	no
schema	no
role	no
authenticator	no
application	no
collect_query_history	no
password	yes; prefer password_ref
private_key	yes; prefer private_key_ref

Default role templates

Offered when a source is created with default roles. Edit them to fit.

analyst

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*

blocked

Effect	Action	Resource type	Pattern
deny	*	*	*

power_analyst

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*

warehouse_admin

Effect	Action	Resource type	Pattern
allow	*	*	*

writer

Effect	Action	Resource type	Pattern
allow	db.schema.list	db.schema	*
allow	db.table.describe	db.table	*.*
allow	db.table.select	db.table	*.*
allow	discovery.search	discovery.asset	*
allow	discovery.asset.read	discovery.asset	*
allow	db.table.insert	db.table	*.*
allow	db.table.update	db.table	*.*