title: Bigquery-Update command
body: <p>I am trying to update values of column page in my table page_perf.but i keep getting error message:<strong>Encountered " "UPDATE" "update "" at line 1, column 1. Was expecting: </strong></p>
  
  <p>Code:</p>
  
  <pre><code>update 'possible-stock-172109:180417Page_dataset.page'
      set unique_id = LEFT(SUBSTR(page,5,22),22)
      where Product = "HT_AMP";
  </code></pre>