title: What is the insert overwrite work around in bigquery?
body: <p>I have already tried this:</p>
  
  <pre><code>update `cmi.sourav_test_bq_mg` b 
  set b.name=a.name 
  from `cmi.sourav_test_bq_mg_2` a 
  where a.id=b.id 
  </code></pre>
  
  <p>but it only worked for for rows where the condition matched, rather than for all of the every data. How can I updated all of it?</p>