Tag: Data Modeling

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.