A view that stores its query output ahead of time. A serverless pipeline maintains it, refreshing it on demand with REFRESH MATERIALIZED VIEW, on a schedule or when upstream data changes, incrementally when it can.
Also called MV.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Materialized view in context, with comparison tables and the common traps.
Terms in this definition
- View
Shows a system through one chosen group of related concerns. No view is generic; each one is tied to whichever architecture it depicts.
- Serverless
Compute tier for single Azure SQL databases that scales automatically, pauses when idle and charges by the second. It is offered in General Purpose and Hyperscale, not Business Critical, and reserved capacity does not apply.
- Pipeline
Groups activities logically so that, together, they move and transform data, either one after another or side by side; found in both Azure Data Factory and Microsoft Fabric.
Related terms
- Full refresh
A pipeline run that wipes the stored data and state of a streaming table or materialized view and then rebuilds it from every source record; anything already deleted at the source cannot come back.
- SCHEDULE clause
Sets a timed refresh for a streaming table or materialized view.
SCHEDULE EVERYtakes an interval in hours, days or weeks, andSCHEDULE CRONtakes a Quartz cron expression when exact or more frequent than hourly timing is needed. - UNDROP
Recovers a managed or external Unity Catalog table, or a materialized view, after it has been dropped, within a 7-day default window. List options using
SHOW TABLES DROPPED; choose one byUNDROP TABLE WITH ID. - Validation table
Typically a materialized view using
expect_or_failto confirm something across datasets, e.g. row counts agreeing. Because downstream tables aren't blocked by it, put checks in their own pipeline and chain pipelines with a job.