Hello!
I need to build a Looker dashboard for a script that was built with Firestore as part of a Firebase project. This is for a web app project (not a mobile app).
The dashboard aims at capturing usage data such as:
- KPI: Total cost spend (filter by period, start date, end date): single bar spend vs total (e.g. 400usd spent vs 2000USD allowance)
- Table: List of all users autorized and active, total cost for each row, current period cost
- Pie chart: model usage
I understand that Firebase cannot integrate directly with Looker so chose to build the dashboard with data flowing through BigQuery.
I linked BigQuery to my Firebase project. After waiting 24 hours, the project was linked but not exporting (see screenshot).
When I toggled on “Performance Monitoring” (as I believe the data we are trying to capture are considered as part of Performance Monitoring category), I see a message with “Dataset not created”.
In BigQuery, I have a project, dataset and location (matching the one I selected when toggling on Performance Monitoring)
We already have usage data in our Firebase project however it is historical data that were in the project before I started linking to BigQuery / building the dashboard.
I have already asked Gemini in Firebase and the Firebase support team but they directed me to here. I have also searched the community posts but couldn’t find an answer.
As this is the first time I have to build a dashboard with BigQuery and Firebase, I am not sure what I am missing and I am now wondering if I am made the right decision by building the dashboard with BigQuery.
- What do I miss in the integration between Firebase and BigQuery? Can you see something I don’t?
- Would adding new data maybe help with the export?
Thanks for your help!