title: How to insert/update a partitioned table in Big Query
body: <p><strong>Problem statement:</strong>
  I need to insert/update a few columns in a big query table that is partitioned by date.So basically I need to do the necessary changes for each partitioned date (done by day).<br>
  (its the sessions table that is created automatically by linking the GA View to BQ so I haven't done the partition manually but its automatically taken care by google). </p>
  
  <p>query reference from <a href="https://cloud.google.com/bigquery/docs/using-dml-with-partitioned-tables" rel="nofollow noreferrer">google_docs</a></p>
  
  <p>my query:</p>
  
  <p><a href="https://i.stack.imgur.com/zr9AT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zr9AT.png" alt="MY QUERY AND ERROR"></a></p>
  
  <p>I also tried the below :</p>
  
  <p><a href="https://i.stack.imgur.com/jPJV3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jPJV3.png" alt="enter image description here"></a></p>
  
  <p>Can anyone help me here ? sorry I am a bit naive with BQ. </p>