Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
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 Azure 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:
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. |