BigQuery is a fully managed, petabyte-scale, and cost-effective analytics data warehouse that lets you run analytics over vast amounts of data. You can use the following Firebase Extensions to connect Cloud Firestore with BigQuery:
Stream Cloud Firestore data to BigQuery
Send real-time, incremental updates from a Cloud Firestore collection to BigQuery. Learn more.
Export BigQuery query results to Cloud Firestore
Schedule and export BigQuery query results in Cloud Firestore for real-time delivery. Learn more.