Enqurious LogoTM

Use coupon code 'ENQSPARKS25' to get 100 credits for FREE

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
masterclass poster
Industry
general
Skills
data-storage
data-wrangling
batch-etl
approach
data-understanding
data-visualization
data-modelling
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