Go back
Introduction to SQL Warehouse: Compute, Dashboard & Alerts
3 Scenarios
1 Hour 30 Minutes
Intermediate
Industry
general
Skills
data-understanding
data-visualization
batch-etl
approach
data-storage
data-modelling
data-wrangling
Tools
databricks
sql
Learning Objectives
Understand the role of Databricks SQL Warehouse in running SQL workloads
Explore different SQL Warehouse options and their features
Learn how to set up alerts
Create dashboards for business insights using SQL queries and visualizations
Overview
This module introduces Databricks SQL Warehouse and its role in running SQL workloads efficiently within a lakehouse architecture. It explains how SQL Warehouse provides compute for queries without requiring Spark clusters or notebooks. You will explore different SQL Warehouse options—Classic, Pro, and Serverless—along with features like Auto Stop, Scaling, and Intelligent Workload Management (IWM) to optimize performance and cost.
The module also covers how to monitor inventory levels, set up alerts, and define trigger conditions to prevent stockouts. Additionally, it explains how to create dashboards for visualizing business insights using SQL queries, charts, and graphs.
Prerequisites
- Basic understanding of SQL
- Familiarity with Databricks