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.

Get started

The following pages contain 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

Build and manage your data warehouse using the following core tools:

Tool	Description
Metric views	Semantic layer for defining business metrics with consistent calculations.
SQL Editor	In-platform SQL editor for collaborative authoriing, exploring results, and scheduling queries.
Queries	View tools for creating and managing queries. Use query parameters and filters to focus results. Work with query snippets to create reusable SQL.
Alerts	Use alerts to automate query runs, evaluate custom conditions, and delier notifications whne those conditions are met.
Monitor query performance	Review query performance. Identify bottlenecks and opportunities for optimization.