Search code examples
firebasegoogle-cloud-firestoregoogle-bigqueryfirebase-extensions

Export Collections to BigQuery

I have tried to export collection to BigQuery using Export Collections to BigQuery extension.
But I am not able to export all collections.

I need to export all collection and subcollection to BiqQuery using Export Collections to BigQuery extensions

I am able to export only one collection but can't export all.

Could anyone please help me to export all collections and subcollections?

Solution

  • You can try to export the information to a bucket or a local file by running the command gcloud firestore export gs://mybucket/my/path as mentioned here. This will export all the collections with a single command.

    I recommend you to export it to GCS, however, you can load the info to BigQuery by following one of these methods.

    There most likely is an issue with the extension you are using since extensions are still on beta, but you can still open a Feature request so that they add more functionalities to the extension in the future and/or report any bug directly.

    Hope you find this useful!