Identity dedup in a medallion lakehouse: the nulls no one catches

A credit bureau came to us partway through moving its reporting platform off an aging on-prem monolith and onto an AWS lakehouse, and the part that had stalled them was the one that sounds the most bo