Building Lakehouses on Delta Lake with SQL Analytics

Overview

Explore techniques for building a lakehouse using Delta Lake, performing exploratory analysis with SQL Analytics, and establishing connectivity for BI applications in this 31-minute video from Databricks. Learn about lakehouse architecture patterns, performance optimization tips, and SQL Analytics operations. Discover how to enable a good BI experience, understand data security governance models, and see a practical implementation example using TPCDI. Gain insights into frictionless loading, SQL Analytics, and Power BI integration through a comprehensive demo. Enhance your understanding of modern data management and analytics solutions for building efficient and scalable data lakehouses.

Syllabus

Introduction
Agenda
What is Lakehouse
Lakehouse Architecture Pattern
Stats Collection
Zorder
Partitioning
Performance tips
Why did we create SQL Analytics
What does SQL Analytics look like
SQL Endpoint Management
SQL Analytics Operations
How to Enable a Good BI Experience
Price Performance
Use Cases
Data Security Governance
Common Governance Models
Unity Catalog
Implementation Example
What is TPCDI
Implementation Reference Architecture
frictionless loading
Demo
frictionless loading notebooks
pass parameters
SQL Analytics
Power BI
Conclusion