Error "does not contain valid backup metadata" when trying to CREATE TABLE in BigQuery from Firestore Backup

0
votes

I've created data base via Google Firestore and I'm trying to display it in BigQuery. First I export a backup to Storage Bucket via Google Shell (according to documentation). Then I enter BigQuery and when I try to Create table I always get an error. Here is what your documentation says: Verify [KIND_COLLECTION_ID] is specified in your Cloud Storage URI. If you specify the URI without [KIND_COLLECTION_ID], you receive the following error: does not contain valid backup metadata. (error code: invalid).

I've tried every file in my Bucket and I always get errors like: gs://olimp-data/2019-03-28T11:39:33_12594/2019-03-28T11:39:33_12594.overall_export_metadata does not contain valid backup metadata.

or

Entity was of unexpected kind "olimp".

1
google-bigquerygoogle-cloud-firestore

1 Answers

3
votes

The Documentation says:

Note: Do not use the file ending in overall_export_metadata. This file is not usable by BigQuery.

Please use other file:

The URI for your Cloud Firestore export file should end with [KIND_COLLECTION_ID].export_metadata. For example: default_namespace_kind_Book.export_metadata. In this example, Book is the collection ID, and default_namespace_kind_Book is the file name generated by Cloud Firestore.

and export specific collections as described here: https://firebase.google.com/docs/firestore/manage-data/export-import#export_data