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.

How to use Databricks SQL

Databricks SQL runs on SQL warehouses and supports ANSI SQL with Delta Lake extensions. You can access Databricks SQL from multiple interfaces for querying, visualization, and automation.

Interface	Description
Query editor	Write and execute SQL queries with integrated Databricks Assistant, code comments, and version history for collaborative query development.
Notebooks	Attach a notebook to a SQL warehouse to run SQL alongside Python, Scala, or R. See Notebooks and SQL warehouses for limitations.
Jobs	Schedule SQL queries as jobs for automated data processing and reporting workflows.
Dashboards	Create interactive AI/BI dashboards with AI-assisted authoring to share insights across your organization.
Metric views	Define business metrics with consistent calculations using a semantic layer. Reuse metrics across queries and dashboards.
Alerts	Schedule automated query runs, evaluate custom conditions, and deliver notifications with alert history tracking.
Query performance monitoring	Review query performance, identify bottlenecks, and find optimization opportunities.
REST API	Automate tasks on Databricks SQL objects programmatically using the REST API.

To learn more about using Databricks SQL, see:

• SQL language reference
• Connect to a SQL warehouse
• Databricks SQL release notes

Get started

New to Databricks SQL? Build your understanding with foundational concepts, then apply what you've learned with hands-on tutorials.

Resource	Description
Data warehousing architecture	Understand lakehouse architecture, medallion layers, and data modeling approaches for building data warehouses.
Databricks SQL concepts	Learn core Databricks SQL concepts including queries, SQL warehouses, dashboards, and data management.
Get started with data warehousing using Databricks SQL	Follow a complete walkthrough covering sample dashboards, notebooks, jobs, data ingestion, and SQL warehouse setup.
Create an AI/BI dashboard	Build and publish your first dashboard with datasets, visualizations, and filters using AI-assisted authoring.
Unity Catalog metric views	Define consistent, reusable business metrics with a semantic layer for use across queries and dashboards.