Avoiding Entity Key Drift in a Data Lake: Step 1, Normalization

Assigning unique IDs directly to raw identifier strings in a data lake is a shortcut that inevitably corrupts your data over time. Simple variations like typos, spacing, or capitalization cause these identifiers to "drift," which splits a single real-world entity into multiple, fragmented keys. This fragmentation silently breaks