Hi Folks,
My company has a mobile app with lots of data stored in Firestore collections. We'd like to run data analytics on the dataset, but I'm not clear on the most efficient way to get the Firestore data to BigQuery for analysis. We'd like to get the data into BigQuery and automatically keep it up to date periodically to run analytic reports and create dashboards based on various aggregations.
I'm technical but not a professional developer, so I prefer to work with no-code or low-code tools as much as feasible.
The dataset would probably be up to several million rows, by a dozen or so columns for a typical collection.
Any advice on the best way to move Firestore data to BigQuery tables continuously?
Thank you in advance!