Looker dashboard for Firebase web app with BigQuery

[EmmaBetter]

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.

1. What do I miss in the integration between Firebase and BigQuery? Can you see something I don't?
2. Would adding new data maybe help with the export? 

Thanks for your help! 

[Nandha100]

HI @EmmaBetter,

i hope you have done the following steps for looker report,

step1: firebase data exported to Big Query

step2: you have trigger or schedule to load the usage data from firebase data to Big Query

step3: looker source table you have pointed from the Big Query.

if you done like this i think it will works fine. other way directly pointed from firebase project to looker mean every time you have wait for some time also you have refresh.