[Stream Firestore to BigQuery] How many instances of the extension do i need?

[sagarsubedi]

My data looks like this:

/organization/{orgId}/estimates/{estimateId}/spaces/{spaceId}
Each space contains inventory item array which is what i eventually need. These items are the items that belong to an order/estimate.

/organization/{orgId}/inventory
I need all the inventory items that belong to an organization. Now, the inventory sub-collection does have another sub-collection called instances but I dont really need that at all.

I keep getting errors like these:

An error has occurred on the following documents, please re-run or insert the following query documents manually... {"endAt":{"before":true,"values":[{"referenceValue":"projects/PROJECT_NAME/databases/(default)/documents/organizations/1D26zBt2hrJTqX80AebU/estimates/pawzVKZ1hotEpCatYPpx","valueType":"referenceValue"}]}}
Error: Error initializing latest view: Precondition check failed.

I have 3 instances of the same extension (Stream Firestore to BigQuery). One is for organizations (this is at root level). Other for organizations/{orgId}/estimates and the third one for organizations/{orgId}/inventory.
I can see the data that got imported from the organizations collection (the one at the root level) just fine. But no matter what i do i cannot seem to get the inventory and estimates.

I would really appreciate some help here. Thank you for your time.