Step-by-Step: Using the Databricks Excel Add-in to Analyze Governed Lakehouse Data
How to import governed Databricks data into Excel. Discover how business users can easily bring Unity Catalog tables, Metric Views, and shared queries into Excel as refreshable, governed data—no SQL or complex setup required.
0:00 - Intro
0:40 - Opening the add-in
0:47 - Select compute
1:01 - Browse Unity Catalog
1:43 - Apply data filters
2:12 - Import data
2:37 - Refresh data
3:02 - Write a SQL query
3:23 - Access Unity Catalog Metric Views in Excel
4:19 - Access a shared query from Databricks
4:50 - Refresh all queries
🔗 Learn more about the Databricks Add-In for Excel:
https://www.databricks.com/blog/introducing-databricks-excel-add-business-users
Watch on YouTube ↗
(saves to browser)
Sign in to unlock AI tutor explanation · ⚡30
Related AI Lessons
⚡
⚡
⚡
⚡
Data From Cars: The Hidden Information Modern Vehicles Collect — Joseph Sides
Medium · AI
Building a Video Analytics Dashboard with Go and Chart.js
Dev.to · ahmet gedik
Why Your Area Calculation Is Wrong in GeoPandas (And How to Fix It)
Medium · Data Science
Why Your Area Calculation Is Wrong in GeoPandas (And How to Fix It)
Medium · Python
Chapters (11)
Intro
0:40
Opening the add-in
0:47
Select compute
1:01
Browse Unity Catalog
1:43
Apply data filters
2:12
Import data
2:37
Refresh data
3:02
Write a SQL query
3:23
Access Unity Catalog Metric Views in Excel
4:19
Access a shared query from Databricks
4:50
Refresh all queries
🎓
Tutor Explanation
DeepCamp AI