Freeze-and-Squash: Turning Snapshot Tables into a Versioned Change Feed with Fabric Materialized Lake Views Periodic snapshots are a gift and a curse. They’re a gift because they’re easy to land: each load is a complete “as-of” picture, and ingestion rarely needs fancy orchestration. They’re a curse because the moment you want history with meaning—a clean versioned change feed, a Type 2 dimension, a Data Vault satellite—you’re suddenly writing heavy window logic, MERGEs, and stateful pipelines that are harder to reason about than the business problem you were trying to solve. This post describes a Fabric Materialized Lake View (MLV) pattern that “squashes” a rolling set of snapshot tables down into a bounded, versioned change feed by pairing a chain of MLVs with a periodically refreshed frozen table.

#DataSnapshots don’t have to doom you to heavy MERGEs or unbounded refreshes. This #MSFabric #MLV “freeze-and-squash” pattern turns periodic snapshots into a bounded, reusable change feed that can drive both Type 2 dimensions and #DataVault artifacts —without abandoning an MLV-forward architecture.