title: How to configure Google Cloud BigQuery in airflow
body: <p>I'm trying add a connection in my <strong>Apache Airflow</strong> to connect to google cloud in order to use <strong>BigQueryHook</strong>, currently, I have my service account json file stored in <code>airflow-projects -&gt; dags -&gt; keys</code>. From the add connection in <code>Admin -&gt; Connections</code>, I have specified
  <em>Conn Id = bigquery_default</em>, <em>Conn Type = Google Cloud</em> and the <em>Keyfile Path=/keys/serviceKey.json</em>. When i run my dag, I'm getting an error</p>
  <blockquote>
  <p>FileNotFoundError: [Errno 2] No such file or directory: '/keys/serviceKey.json'</p>
  </blockquote>
  <p>I have tried to change Keyfile Path=/dags/keys/serviceKey.json* but still, I'm getting FileNotFoundError. What I'm I missing?</p>
  <pre><code>def get_data_from_bq(**kwargs):
      hook = BigQueryHook(bigquery_conn_id='bigquery_default', delegate_to=None, use_legacy_sql=False)
      conn = hook.get_conn()
      cursor = conn.cursor()
      cursor.execute('SELECT owner_display_name, title, view_count FROM `bigquery-public-data.stackoverflow.posts_questions` WHERE creation_date &gt; &quot;2020-09-09&quot; ORDER BY view_count DESC LIMIT 2')
      result = cursor.fetchall()
      print('result', result)
      return result
  </code></pre>