Databricks Metric Views
Databricks Unity Catalog Metric Views, kept as YAML files in your repository. dex reads them with no workspace connection, authors them as reviewable diffs, and holds them to the warehouse when columns move. Nothing is deployed for you.
Why connect Databricks Metric Views?
Databricks Unity Catalog Metric Views define your measures and dimensions over Unity Catalog tables. Dex works on the YAML files you deploy them from: it reads them with no workspace connection, authors them as reviewable diffs, and tells you when they fall out of sync with the warehouse.
- 1Keep Metric View definitions in your repository, reviewed like code
- 2Derive a Metric View from a declared dbt mart, or convert one from an Apache Ossie document and back
- 3Measure the one-match keys your joins declare against the data they claim
- 4Nothing deployed for you: Dex validates against the Metric View rules and never touches your workspace
Agent-native analytics engineering on your Databricks Metric Views.
- .dex/config.yml
- metric_views/orders.yaml
How it works
Explore, transform, maintain: the Dex loop on Databricks Metric Views.
- 1
Point Dex at your Metric View files
Install Dex in Claude Code by running
/plugin marketplace add exmergo/exmergo-agent-pluginsand/plugin install dex@exmergo, then add the extra withpip install 'exmergo-dex-core[metric-views]'. Setsemantic.vendor: databricksin.dex/config.ymland list your Metric View YAML files undersemantic.databricks.files.databricks-metric-views/plugin marketplace add exmergo/exmergo-agent-plugins/plugin install dex@exmergopip install 'exmergo-dex-core[metric-views]'
- 2
Read the catalog before you touch anything
/dex:explorereads the fields, measures, and joins your Metric Views declare, with no workspace connection. Each join and each declared one-match key becomes evidence Dex uses when it profiles tables and verifies joins.databricks-metric-views/dex:explore
- 3
Author views as reviewable diffs
/dex:transformwrites and updates your files throughsemantic databricks define, andtransform applycommits them byte-for-byte. A declared dbt mart derives its Metric View, and an Apache Ossie document converts to one and back.databricks-metric-views/dex:transformsemantic databricks definetransform apply
- 4
Nothing is deployed for you
Every file is validated against Dex's port of the Metric View YAML rules, stricter on write than on read, so keys Databricks would refuse are caught before a file is written. Nothing is deployed to your workspace.
- 5
Catch drift automatically
/dex:maintainholds your Metric Views to the warehouse: a field or measure reading a column its table lost, a source that is gone, a date format on a column that is not a date.databricks-metric-views/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.