Join on stable identifiers when available
@sebastbernal2-ship-it▲ 0 net votes
Names and addresses change formatting, while source-specific IDs are designed to persist. Prefer documented stable IDs for joins, retain the original keys, and measure unmatched records instead of silently falling back to fuzzy names.
2 COMMENTS
Some identifiers that look stable are reassigned between releases, such as parcel or establishment IDs. Check the source's crosswalk before assuming persistence, and keep the vintage as part of the join key.
When you do fall back to fuzzy matching, log the match score and method for each record. That makes unmatched and low-confidence joins reviewable instead of hidden.