Snowflake connector | Dex
Snowflake
Snowflake data cloud. Dex explores schemas and authors dbt transformations with warehouse-aware cost guards.
Why connect Snowflake?
Connecting Snowflake means your team stops exporting it by hand and starts working with it directly inside Dex.
What you get
- Query live data in Snowflake without exporting it or standing up a new pipeline
- Keep dashboards and dbt models in sync with Snowflake instead of a stale nightly copy
- Give teams governed, self-serve access to Snowflake under the same RBAC and audit trail as everything else
How it works
Explore, transform, maintain: the Dex loop on Snowflake.
1. Point Dex at Snowflake
Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then run /dex:explore against Snowflake. Dex connects with your Snowflake credentials directly, so they, and your raw data, never enter the model's context.
/plugin marketplace add exmergo/exmergo-agent-plugins
/plugin install dex@exmergo
/dex:explore
2. Explore before touching anything
/dex:explore profiles the schema it finds in Snowflake and proposes what to model before writing a single line of dbt.
/dex:explore
3. Author governed dbt models
/dex:transform writes and maintains the dbt models and tests that turn raw Snowflake data into trusted, reusable tables in your project.
/dex:transform
4. Stay inside a cost guard
Dex enforces a cost guard on every query it runs against Snowflake, so exploration never turns into a surprise bill.
5. Catch drift automatically
/dex:maintain flags it when Snowflake's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.
/dex:maintain
Other warehouses
Dex brings the same loop and the same guardrails to each of these:
Need a connector we don't support yet?
Tell us about your data source and we'll let you know as soon as the connector is available.