title: BigQuery update how to get number of updated rows
body: <p>I am using Google Cloud Functions to connect to a Google Bigquery database and update some rows. The cloud function is written using Python 3.</p>
  
  <p>I need help figuring out how to get the result message or the number of updated/changed rows whenever I run an update dml through the function. Any ideas? </p>
  
  <pre><code>from google.cloud import bigquery
  
  def my_update_function(context,data):
  
      BQ = bigquery.Client()
      query_job = BQ.query("Update table set etc...")
      rows = query_job.result()
      return (rows)
  
  </code></pre>
  
  <p>I understand that rows always come back as _emptyrowiterator object. Any way i can get result or result message? Documentation says I have to get it from a bigquery job method. But can't seem to figure it out.</p>