Study guide
9.3 Scheduled Refresh, Email Subscriptions & Alerts
Databricks Certified Data Analyst Associate Exam
Track your progress as you read
Finished sections get a check mark.
1 Platform Overview & Unity Catalog Foundations
1.1 Databricks Architecture & Compute Concepts 1.2 Databricks Marketplace & Data Sharing Basics 1.3 Unity Catalog Namespace & Object Hierarchy 1.4 Governed Asset Discovery & System Tables
2 Managing & Cleaning Governed Data
2.1 Dataset Discovery & Asset Tagging 2.2 Lineage Inspection & Data Traceability 2.3 SQL Data Cleaning & Transformation Techniques
3 Data Ingestion & Import Patterns
3.1 Workspace Uploads & Cloud File Ingestion 3.2 Incremental File Ingestion with Auto Loader 3.3 Ingesting Data via Delta Sharing & External Connections
4 Databricks SQL Warehouses & Core Querying
4.1 Databricks SQL Interface & SQL Assistant 4.2 SQL Warehouses Sizing & Management 4.3 Table Creation & Data Modification in Databricks SQL
5 Advanced SQL Authoring & Time Travel
5.1 Advanced Aggregations, Window Functions & Analytics 5.2 Complex Joins, CTEs & Set Operations 5.3 Views, Materialized Views & Delta Time Travel
6 Query Performance Analysis & Photon Engine
6.1 Photon Engine Architecture & Acceleration 6.2 Query History & Execution Profile Inspection 6.3 Delta Lake Audit History & Commit Logs
7 Liquid Clustering, Caching & Performance Troubleshooting
7.1 Caching Hierarchy in Databricks SQL 7.2 Data Layout Optimization: Liquid Clustering vs Partitioning & Z-Ordering 7.3 Troubleshooting Slow & Failing Queries
8 AI/BI Dashboards & Visualization Design
8.1 AI/BI Dashboards Overview & Canvas Layout 8.2 Chart Types & Visualization Selection 8.3 Notebook & SQL Editor Visualizations
9 Dashboard Interactivity, Publishing & Alerts
9.1 Dashboard Parameters & Interactive Filtering 9.2 Publishing, Sharing & Access Control 9.3 Scheduled Refresh, Email Subscriptions & Alerts
10 Developing & Maintaining AI/BI Genie Spaces
10.1 AI/BI Genie Architecture & Space Setup 10.2 Curation via Instructions, Descriptions & Sample Questions 10.3 Trusted Assets & Parameterized Functions 10.4 Monitoring, Benchmarks, Feedback & Maintenance
11 Data Modeling & Medallion Architecture
11.1 Dimensional Modeling Fundamentals 11.2 Medallion Architecture for Analytics 11.3 Constraint Enforcement & Relationships in Unity Catalog
12 Securing Data & Unity Catalog Governance
12.1 Unity Catalog Privilege Model & Grants 12.2 Ownership, Inheritance & Access Control Patterns 12.3 Fine-Grained Security: Row Filters & Column Masks
9.3 Scheduled Refresh, Email Subscriptions & Alerts
Key Takeaways Explain This Topic AI
Scheduled refreshes for AI/BI Dashboards can be configured on cron schedules down to minute-level frequencies or triggered via Databricks Workflows jobs.
Email subscriptions deliver PDF or PNG dashboard snapshots alongside CSV dataset exports to specified workspace users and external email addresses if permitted by workspace policy.
Databricks SQL Alerts evaluate single boolean or threshold conditions against query result sets, triggering notifications when metrics breach specified boundaries.
Alert evaluation frequencies range from 1-minute intervals to custom cron schedules, operating independently of dashboard visual canvas rendering.
Notification destinations for alerts and scheduled refreshes include Email, Slack webhooks, Microsoft Teams, PagerDuty, and custom HTTP webhooks.
Last updated: July 2026
Maintaining automated data freshness and configuring proactive notifications are critical components of operational reporting in Databricks. Business decision-makers rely on up-to-date visual metrics and timely alerts when key business indicators breach acceptable boundaries. Databricks provides two distinct mechanisms to handle automated updates and notifications: Scheduled Refresh with Email Subscriptions for AI/BI Dashboards, and Databricks SQL Alerts for standalone query monitoring.
Scheduled Dashboard Refreshes & Engine Architecture
A published AI/BI Dashboard can be configured with an automated Scheduled Refresh . When a schedule triggers, Databricks automatically wakes or utilizes the assigned Databricks SQL Warehouse to re-execute all dataset queries powering the published dashboard canvas, populating the dashboard cache with fresh data.
Scheduled Execution Mechanics
Trigger Phase : The schedule fires based on a predefined UI interval (e.g., Every 2 hours) or a custom 5-field CRON expression (e.g., 0 0 8 * * ? for daily at 8:00 AM).
Compute Allocation : Databricks routes query execution to the SQL Warehouse designated in the dashboard settings. Using Serverless SQL Warehouses for scheduled refreshes is strongly recommended, as serverless warehouses start in seconds and automatically scale down immediately after queries complete.
Cache Updating : The resulting query dataset outputs overwrite cached result sets stored for the published dashboard. Subsequent user visits to the published dashboard load instantly from cache without waiting for query re-execution.
Parameter Context : Scheduled refreshes execute using default parameter values saved in the published dashboard state unless specific parameter overrides are configured in the schedule definition. # Example 5-field CRON schedule for weekdays at 6:00 AM UTC
- 0 6 * * MON-FRI
- Email Subscriptions & Snapshot Distribution
Alongside scheduled refreshes, authors can configure Email Subscriptions to automatically broadcast updated dashboard visual assets to stakeholders.
Subscription Delivery Formats
Subscribers can receive dashboard updates in three complementary formats:
Inline Image (PNG) : A high-resolution rendered visual snapshot of the primary dashboard canvas embedded directly into the body of the email.
PDF Attachment : A multi-page PDF document rendering all dashboard canvas tabs and visual widgets, formatted for printing or executive presentation.
CSV Data Export : Downloadable CSV files attached to the email containing raw result sets for specified underlying SQL datasets.
Distribution Governance & Admin Restrictions
Subscriptions can be delivered to individual workspace users, Databricks user groups, or external email addresses (such as external clients or vendors). However, sending email subscriptions to non-workspace email domains requires workspace admin authorization. In the Databricks Admin Console, administrators can enable or disable external email subscriptions workspace-wide to prevent sensitive corporate metrics from leaving the corporate security perimeter.
Databricks SQL Alerts & Threshold Monitoring
While Dashboard Email Subscriptions send periodic reports regardless of data changes, Databricks SQL Alerts provide proactive, condition-based monitoring. Alerts periodically evaluate the output of a single Databricks SQL query and trigger notifications only when specified data thresholds are breached.
Alert Architecture & Evaluation Workflow
Databricks SQL Alerts operate independently of visual dashboard canvases. They are attached directly to scheduled SQL queries written in the Databricks SQL Editor. -- Query designed for a Databricks SQL Alert monitoring high-latency jobs
- SELECT
- COUNT(*) AS high_latency_count,
- MAX(duration_seconds) AS max_duration
- FROM main.system_logs.job_execution_history
- WHERE execution_date = CURRENT_DATE()
- AND duration_seconds > 3600;
- Alert Condition Configuration
When setting up an alert, the author defines a logical condition based on a column in the query result set:
Value Comparison : Triggers when a specified column value is Greater Than , Less Than , Greater Than or Equal To , Less Than or Equal To , or Equal To a threshold number (e.g., high_latency_count > 0 ).
Null Checking : Triggers when a column Is Null or Is Not Null (useful for detecting pipeline data gaps).
Change Threshold : Triggers when a value changes by a specified absolute amount or percentage compared to the previous execution.
Alert States & Re-notification Policies
Databricks SQL Alerts transition between three operational states:
- Alert State Description Trigger Condition
- OK Query evaluated successfully; condition threshold was NOT breached. high_latency_count == 0
- TRIGGERED Query evaluated successfully; condition threshold WAS breached. high_latency_count > 0
- UNKNOWN Query failed to execute, timed out, or returned 0 rows for evaluation. Execution error or empty result
Authors can configure one of two re-notification policies when an alert enters the TRIGGERED state:
Just Once : Sends a single notification when the state transitions from OK to TRIGGERED . No further notifications are sent on subsequent scheduled query runs as long as the alert remains in TRIGGERED state.
Every Time : Sends a notification on every scheduled execution for as long as the alert remains in TRIGGERED state (ideal for urgent operational outages).
Notification Destinations & Webhook Integration
Both Dashboard Subscriptions and SQL Alerts integrate with Notification Destinations configured in Databricks SQL. Rather than relying solely on email, alerts can broadcast payload notifications to enterprise communication platforms and incident response tools.
Supported Destinations
Email : Direct delivery to specified email addresses.
Slack : Webhook integration posting structured alert messages into designated Slack channels.
Microsoft Teams : Webhook delivery into Teams channel channels.
PagerDuty : Incident creation for critical production threshold breaches.
Generic Webhooks : Standard HTTP POST requests delivering JSON payloads to custom API endpoints, AWS Lambda functions, or external workflow engines. // Example payload delivered by a Databricks SQL Alert Generic Webhook
- {
- "event_type": "ALERT_TRIGGERED",
- "alert_id": "alert-884920",
- "alert_name": "Job Latency SLA Breach",
- "state": "TRIGGERED",
- "query_id": "query-55123",
- "value": 14,
- "threshold": 0
- }
- Comparing Dashboard Refreshes vs. SQL Alerts
Feature Dimension Dashboard Scheduled Refreshes Databricks SQL Alerts
Primary Purpose Periodic reporting & visual canvas distribution Real-time threshold monitoring & incident alerting
Evaluation Scope All queries across an entire dashboard canvas A single, targeted SQL query
Trigger Mechanism Fixed time schedule or CRON expression Fixed time schedule evaluated against boolean data logic
Output Payload Visual canvas snapshot (PNG/PDF) or CSV export Structured text message with metric values & query link