firebase / extensions

Source code for official Firebase extensions
https://firebase.google.com/products/extensions
Apache License 2.0
882 stars 372 forks source link

Subcollections not importing via the form #1980

Open sorrel-certifyos opened 3 months ago

sorrel-certifyos commented 3 months ago

[READ] Step 1: Are you in the right place?

Issues filed here should be about bugs for a specific extension in this repository. If you have a general question, need help debugging, or fall into some other category use one of these other channels:

[REQUIRED] Step 2: Describe your configuration

[REQUIRED] Step 3: Describe the problem

When I configure the extension to a subcollection and select yes for importing existing firestore documents into BigQuery, I expect the subcollection documents to import. They do not. Newly created documents are added to the table in BigQuery via extension, so it appears specifically the import on the subcollection is not working. I have tried both with and without a transform function. With the transform function, after about an hour I get a document count of how many documents were imported, but no documents were added to the big query table, and the transform function was never invoked per the logs on the transform function. Without a transform function, the "runtime status" reads, "Configuring BigQuery Sync and running import if configured" but it never imports any documents (though newly created ones are added to the table), and the status does not change (it's been about 3 days now).

My expectation is that the subcollection documents would import into the big query table (as directly importing a collection does)

Steps to reproduce:

What happened? How can we make the problem occur?

Use a configuration similar to above, with your equivalent subcollection and db values create a new extension

Expected result

Subcollection documents (which, the specific extension is set up only for the subcollection) will import into the extension's bigquery table. All of them. Ideally after being transformed via the transform cloud function specified in the configuration.

Actual result

Although the extension is created, and new documents are created in the raw_changelog table, nothing is imported and there is no feedback of error or issue.