Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Do I need create tables manually in Google BigQuery to view the raw event data from Firebase?

I had created a android App with Google Firebase supported and linked to the BigQuery yesterday.

Today I've seen the event report on the Firebase Console, but after I clicked the View button in the Event page like the image below

enter image description here

I saw none table in the BigQuery page and got a warning saying the project's table is dismissing.

I wonder if I need do something, like creating some table manually or calling some Firebase or BigQuery APIs in my app. But I've looked up the official document which saying

Once an app is linked to BigQuery, a corresponding dataset will be created in the associated BigQuery project upon the first daily export of events. Each day, raw event data for each linked app populates a new table in the associated dataset.

It seems I need do nothing. So what's the problem here?

like image 218
Yantao Xie Avatar asked Jun 28 '16 06:06

Yantao Xie


People also ask

Do you need a table to hold a dataset in BigQuery?

A table or view must belong to a dataset, so you need to create at least one dataset before loading data into BigQuery.


1 Answers

After you link your Firebase app to BigQuery, the next day, your events will flow from Firebase to BigQuery and this will automatically create the BigQuery dataset and its first daily table. Keep in mind that if your app is not logging any events, then no events will be sent to BigQuery. And the dataset will not be created until some events have been logged after the linkage.

like image 134
Steve Ganem Avatar answered Sep 18 '22 05:09

Steve Ganem