title: BigQuery emulator with local instance of the Apache Airflow
body: <p>I'm working on a project for integration different data sources into Google BigQuery.
  It is the batch approach.
  We are using Apache Airflow for orchestration.</p>
  <p>Simplified flow is: create raw tables (predefined DDL) -&gt; call python code to do batch insert (via bq python client) -&gt; trigger different SQL for transformations -&gt; end</p>
  <p>For testing purposes, we're using the GCP dev project.</p>
  <p>But, recently, I found BigQuery Emulator: <a href="https://github.com/goccy/bigquery-emulator" rel="nofollow noreferrer">BigQuery Emulator</a>.
  Python client example works just fine: <a href="https://github.com/goccy/bigquery-emulator#2-call-endpoint-from-python-client" rel="nofollow noreferrer">BigQuery Emulator: Call endpoint from python client</a></p>
  <p>I'm curious about how to configure the local instance of Airflow to use this emulator. <br>
  I didn't find a way to point <code>BigQueryExecuteQueryOperator</code> to use the emulator. We are using this operator to trigger all our SQL.</p>
  <p>I tried to set 'gcp_conn_id' but it always fails with <code>&quot;Could not automatically determine credentials. Please set GOOGLE_APPLICATION_CREDENTIALS or explicitly create credentials and re-run the application. For more information, please see https://cloud.google.com/docs/authentication/getting-started&quot;</code></p>
  <p>As connection type I tried <code>HTTP</code> and <code>Google Bigquery</code>, no difference.</p>
  <p>Airflow version: 2.3.4 <br>
  bigquery-emulator: 0.1.11</p>