title: Getting the JSON data from the "Export Collections to BigQuery" firebase extension into row column format
body: <p>I'm currently using the <code>Export Collections to BigQuery</code> Firebase Extension.</p>
  
  <p>This is a Firebase Function that periodically updates Firestore Collections to BigQuery.</p>
  
  <p>This is great, but it seems to put Firestore Document Data into a "data" column inside BigQuery.</p>
  
  <p>My question, how would I go about getting this JSON out of the data column into separate columns in BigQuery. Luckily my JSON/Firestore documents are not nested and are flat and I intend to keep it that way.</p>
  
  <p>Any advice would be great. I'm aware of <a href="https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions" rel="nofollow noreferrer">https://cloud.google.com/bigquery/docs/reference/standard-sql/json_functions</a> but am struggling to find the right SQL query to achieve this.</p>