"Stream Firestore to BigQuery" Firebase Extension - live setup + some bugs & caveats
Lukas Oldenburg from dim28 activates streaming to BigQuery for a Firestore collection in a Google Cloud Project, using Firebase's "Stream Firestore to BigQuery" Extension.
The Firestore Extension links a Firestore Collection to a BigQuery dataset (which it creates if it does not exist). Whenever a document in the Firestore collection is created or updated/deleted, the content of the document is inserted into a "changelog" table in BigQuery.
There are several caveats (and bugs) though, so make sure you watch the video to the end, and read the accompanying article for more context:
🐬 https://thebounce.io/firestore-tip-6-... 🐬
(The bug with the Firestore timestamp field not getting recognized has since been fixed)
More on the Adobe Analytics Component Manager for Google Sheets, by Datacroft: https://bit.ly/component-manager
Firebase "Stream to BigQuery" Extension page
Subscribe to Lukas Oldenburg's blog posts: / lukas-oldenburg