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.
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. |