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.
- 1Define entities, dimensions, measures, and metrics once in your dbt project instead of again in every downstream tool
- 2Author and update semantic models as reviewable diffs, validated against a dev target before anything merges
- 3Catch semantic drift when the warehouse moves underneath a metric, before a dashboard shows the wrong number
- 4Keep dbt the single source of truth for what a metric means, for the engineers who define it and the people who chart it
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-pluginsand/plugin install dex@exmergo, then run/dex:exploreagainst dbt Semantic Layer. Dex connects with your dbt Semantic Layer credentials directly, so they, and your raw data, never enter the model's context.dbt/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 dbt Semantic Layer and proposes what to model before writing a single line of dbt.dbt/dex:explore
- 3
Author governed dbt models
/dex:transformwrites and maintains the dbt models and tests that turn raw dbt Semantic Layer data into trusted, reusable tables in your project.dbt/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:maintainflags it when dbt Semantic Layer's schema changes and proposes the fix, instead of letting your dbt project silently drift out of sync.dbt/dex:maintain
Other semantic layers
Dex brings the same loop and the same guardrails to each of these.
Apache Ossie
SLayer
Cube
Snowflake Semantic Views
Databricks Metric ViewsNeed 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.