From Dev.to
BigQuery MERGE Is Not a Uniqueness Constraint: A Replay-Safe Tutorial
A MERGE can be atomic and still leave duplicate business keys. The missing ingredient is a clear key and version contract. This tutorial builds a current-state orders table, not an event-history table...