Enqurious LogoTM

Use coupon code 'ENQURIOUS25' to get 10 credits for FREE

Ending in
0
0
Days
0
0
Hours
0
0
Minutes
0
0
Seconds

SQL Warehouse Fundamentals: Compute, Dashboards & Alerts

3 Scenarios
1 Hour 30 Minutes
Intermediate
item card poster cover image
Free
4 credits
Industry
general
Skills
approach
data-understanding
data-storage
data-modelling
batch-etl
data-wrangling
data-visualization
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