Export Firestore collections to BigQuery and use Data Studio to analyze and aggregate data
In this talk we show how to configure the “Export Collections to BigQuery” extension to export Firestore data to BigQuery, how to execute aggregation queries on this data in BigQuery and, finally, how to create Data Studio reports to visualize and analyze our Firestore data in a user-friendly way.
Links:
Firebase extension documentation → https://bit.ly/3vfajEB
Counters in Firestore → https://bit.ly/3DX55AL
BigQuery documentation → https://bit.ly/3ve7nrU
BigQuery JSON functions → bit.ly/3jng9PN
Data Studio overview → https://it.ly/3ADwGod
Drill down with Data Studio → https://bit.ly/2YVL7Y3
#FirebaseSummit