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: Data Modeling
All posts2 articles tagged Data Modeling.
GENERATED BY DEFAULT vs GENERATED ALWAYS in Databricks
When defining identity columns in Databricks tables, two common options for automatic identity value generation are GENERATED BY DEFAULT and GENERATED ALWAYS. This article explains the differences and when to use each.