S2:E14
Metric Views in Databricks: The Missing Layer for AI Agents
Host
Jonny DaenenGuest
Stefan Van RaemdonckAI is only as good as the layer underneath it. That layer in Databricks is called a Metric View: a semantic model that defines your measures, your joins, and the rules for how data fits together.
In this episode, Stefan walks through the full stack end-to-end on a real LEGO dataset: building Metric Views in Databricks, generating them with dbt, deploying through Databricks Asset Bundles, and finally exposing it all through a Genie Space that business users can chat with. Along the way we get into some deeper questions: what the limits of metric views look like, how access control works, what BI "shifting left" actually means for engineering teams, and how you organize this in data products.
If you saw our Snowflake Intelligence episode, this is the Databricks counterpart. The Snowflake episode can be found here: www.youtube.com/watch?v=Gp-BntPgpcU
Chapters
- 00:00Intro
- 00:50Meet Stefan
- 01:43Demo: talking to your LEGO data
- 07:17Why semantic layers? Data products explained
- 11:20What's in a metric view?
- 14:15Creating Metric Views in Databricks
- 16:29The LEGO data model
- 18:17Data Products & Metric Views in Databricks
- 22:07Are we limited to predefined measures?
- 23:16Building: native Databricks SQL bundles
- 29:12Building: dbt
- 31:16Maintenance and BI shifting left
- 33:59Deploying dbt on Databricks
- 35:29Creating the Genie Space
- 38:24Access Control and Permissions in Data Queries
- 39:28Writing SQL on top of Metric Views
- 40:10Takeaways and favorite Lego

