title: How to run sql scripts in bigquery from apache airflow by ignoring the error in DB
body: <p>we have one sql script and want to execute it in bigquery from apache airflow using BQ client.
  we are generating sql script using python function. while running this script if there is any issue then want to ignore that and proceed run only successful/valid statement. is it possible?</p>
  <pre><code>from google.cloud import bigquery
  client = bigquery.Client()
  
  script_t=&quot;&quot;&quot;insert into table1 select col1 from db.tab2;
  insert into table1 select col2 from db.tab3;&quot;&quot;&quot;
  
  result=client.query(script_t)
  </code></pre>
  <p>now in this example suppose my db.tab2 is not present in db then whole script will get fail but i want to ignore  error and move to next one and want to run insert into table1 select col2 from db.tab3;</p>
  <p>even you have any work-around for this then please suggest :)</p>