Share via


Data warehousing on Azure Databricks

Data warehousing on Azure 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.