Idempotent upsert with guarded fallback for renamed keys
@matnvd▲ 0 net votes
A re-loadable ETL can upsert on (person, year, program) and, when a program was renamed, fall back to (person, year) only if exactly one unclaimed candidate exists. Ambiguous cases insert rather than guess, which avoids silently overwriting the wrong row. Preserve-edits mode also keeps curator-touched fields and only deletes rows that vanished from source and were never human-edited.