A view written in Spark SQL whose output Fabric stores as a Delta table and keeps up to date. The lakehouse has to have schemas enabled.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Materialized lake 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.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Lakehouse
Fabric storage item in OneLake that holds structured and unstructured content side by side: managed Delta tables go under Tables, other files under Files. Spark is used for processing, and a read-only SQL analytics endpoint allows T-SQL queries.