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.
- 1Query live data in Snowflake without exporting it or standing up a new pipeline
- 2Keep dashboards and dbt models in sync with Snowflake instead of a stale nightly copy
- 3Give teams governed, self-serve access to Snowflake under the same RBAC and audit trail as everything else
Agent-native analytics engineering for your dbt project.
- staging/stg_snowflake.sql
- semantic/snowflake_metrics.yml
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-pluginsand/plugin install dex@exmergo, then run/dex:exploreagainst Snowflake. Dex connects with your Snowflake credentials directly, so they, and your raw data, never enter the model's context.snowflake/plugin marketplace add exmergo/exmergo-agent-plugins/plugin install dex@exmergo/dex:explore
- 2
Explore before touching anything
/dex:exploreprofiles the schema it finds in Snowflake and proposes what to model before writing a single line of dbt.snowflake/dex:explore
- 3
Author governed dbt models
/dex:transformwrites and maintains the dbt models and tests that turn raw Snowflake data into trusted, reusable tables in your project.snowflake/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:maintainflags it when Snowflake's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.snowflake/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.