Data warehousing on Databricks

Data warehousing on Databricks combines cloud data warehousing capabilities with lakehouse architecture. Databricks SQL provides the tools and services to build highly-performant, cost-effective data warehouses that run directly on your data lake.

Getting started

Essential resources for beginning your data warehousing journey:

Topic	Description
Data warehousing architecture	Architecture and patterns including lakehouse design, medallion layers, and data modeling approaches.
Databricks SQL concepts	Core concepts and terminology for understanding Databricks SQL and data warehousing.
Queries and data visualization	Step-by-step tutorial for creating queries and building visualizations.

Core tools

Key tools for building and managing your data warehouse:

Tool	Description
SQL Editor	In-platform SQL editor for authoring and scheduling queries.
Queries	Query management features including history, caching, and optimization.
Metric views	Semantic layer for defining business metrics with consistent calculations.