Hash Keys vs Identity Columns: Choosing Surrogate Keys in the Lakehouse
Deterministic hash surrogate keys or IDENTITY columns for your dimensions? A practitioner's pros and cons across load order, idempotency, join cost, and reprocessing.
Tag: Delta Lake
All posts2 articles tagged Delta Lake.
VACUUM vs CDF in Microsoft Fabric: How to Protect Incremental Loads from Silent Data Loss
VACUUM keeps Delta tables healthy, but it can also break Change Data Feed replay windows. This walkthrough shows exactly when incremental pipelines fail and how to design a safe Fabric pattern with guardrails and fallback recovery.