
Technical
BigQuery Error: UPDATE/MERGE must match at most one source row for each target row
Using the SQL MERGE statement with BigQuery can be a huge boost to analytical transformation and data analysis processing but it does have a few gotchas.