dbt Semantic Layer connector | Dex
dbt Semantic Layer
The dbt semantic layer (MetricFlow), local or through dbt Cloud. Dex authors and maintains your entities, dimensions, measures, and metrics as reviewable diffs, validated against a dev target.
Why connect the dbt Semantic Layer?
The dbt Semantic Layer is where your team defines what a metric means, once, in MetricFlow. Dex authors and maintains those definitions as reviewable diffs, locally or through dbt Cloud, and Viz charts the same definitions without copying them into a BI tool.
What you get
- Define entities, dimensions, measures, and metrics once in your dbt project instead of again in every downstream tool.
- Author and update semantic models as reviewable diffs, validated against a dev target before anything merges.
- Catch semantic drift when the warehouse moves underneath a metric, before a dashboard shows the wrong number.
- Keep dbt the single source of truth for what a metric means, for the engineers who define it and the people who chart it.
In your repository Dex
Agent-native analytics engineering for your dbt project.
- models/marts/fct_orders.sql
- models/semantic/orders.yml
How it works
Explore, transform, maintain: the Dex loop on dbt Semantic Layer.
1. Point Dex at dbt Semantic Layer
Install Dex in Claude Code by running /plugin marketplace add exmergo/exmergo-agent-plugins and /plugin install dex@exmergo, then run /dex:explore against dbt Semantic Layer. Dex connects with your dbt Semantic Layer 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 dbt Semantic Layer 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 dbt Semantic Layer 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 dbt Semantic Layer, so exploration never turns into a surprise bill.
5. Catch drift automatically
/dex:maintain flags it when dbt Semantic Layer's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.
/dex:maintain
Other semantic layers
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.