title: Using Airflow template files and template_searchpath in Google Cloud Composer
body: <p>I'm using the <code>BigQueryOperator</code> extenstively in my Airflow DAGs on Google Cloud Composer.</p>
  
  <p>For longer queries, it's better to put each query in its own <code>.sql</code> file rather than cluttering up the DAG with it.  Airflow seems to support this for all SQL Query operators, including the BigQueryOperator, as you can see in <a href="https://github.com/apache/incubator-airflow/blob/master/airflow/contrib/operators/bigquery_operator.py#L35" rel="noreferrer">the documentation</a>.</p>
  
  <p>My question: after I've written a my sql statement in a <code>.sql</code> template file, how do I add it to Google Cloud Composer and reference it in a DAG?</p>