title: How to export firestore sub-collection to bigquery table?
body: <p>We need to export Firestore data to Bigquery for data studio reporting. </p>
  
  <p>We are following the below process -</p>
  
  <ol>
  <li>We export the entire firestore database to google storage bucket</li>
  <li>Through scheduled job we export data from bucket to bigquery</li>
  </ol>
  
  <p>Our Firestore has many subcollections and we are not able to export the subcollections.</p>
  
  <p>Need expert advice - How can we export firestore sub-collection to bigquery table (Ideally different subcollection to different big query tables)</p>