On same systems, like BigQuery you might need to add a where clause, therefore:

update table set target = source where 1=1;