title: BigQuery parameterized queries in Airflow
body: <p>I'm trying to create a parameterized query in BigQuery using Airflow. The parameter that will be set in Airflow and will change the value inside the query that will run in BigQuery.</p>
  <p>For example, this is my query:</p>
  <blockquote>
  <pre><code>select id from table where id = {{params.number_days}}
  </code></pre>
  </blockquote>
  <p>The airflow code includes:</p>
  <blockquote>
  <p>(
  task_id='table',
  use_legacy_sql=False,
  write_disposition='WRITE_TRUNCATE',
  allow_large_results=True,
  bql=merchant_rank_query,
  destination_dataset_table='prod.table_result',
  params = {'number_days': 1},
  dag=dag)</p>
  </blockquote>
  <p>This does not work, what's the correct way?</p>