Score:0

I am trying to import firestore databse to big query using extension, however the sub collections are not getting populated, have tried multiple ways

au flag

I want to sync Big Query with Firestore Database. I have used the extension to import Firestore DB to Big Query however the subcollections are not getting exported to Big Query. I have even tried to make multiple instances of each subcollection that way I do have subcollection data but the data is disconnected from other tables. I want all the data in one table so whenever Firestore gets updated Big Query also gets updated. Have been stuck on this for weeks, mean a lot if I can get step by step guidance as to what I should do. I just got started with Big Query and working on a Cloud Platform. Any help will be highly appreciated.

rsalinas avatar
ca flag
Have you used the [import script](https://github.com/firebase/extensions/blob/master/firestore-bigquery-export/guides/IMPORT_EXISTING_DOCUMENTS.md) in order to populate your bigquery instance? AFAIK, the extension only sends the content of documents that have been changed, it does not export your full dataset of existing documents into BigQuery. You need to do that through the import script
Nabeel Ahmed avatar
au flag
yes I have done that as well
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.