1

A while back we got an email from Google saying they would move all our Firebase Analytics data in BigQuery to a new table and a new schema. Fair enough.

A couple of days ago, the change was made. But the problem now is that we only see null events in our <project>:analytics_xxxxx_.events_<date> table. The events are correct in the intraday table, but for the last three days we only have null values in the events table. Anyone else seen this? Did we do something wrong or is it a bug with Google BigQuery?

enter image description here

KimHafr
  • 2,922
  • 3
  • 26
  • 28
  • Same for me. Only null values. – Christer Nordvik Jun 26 '18 at 22:35
  • @kimHafr, how did you obtain the "Firebase Analytics Property ID" that the sh scripts requires (PROPERTY_ID). I've not been able to find it in my Firebase settings. – Cesar Vinas Jul 02 '18 at 19:04
  • In the firebase dashboard for your app - Select Dashboard in the Analytics section. Then you should see a Analytics Settings button in the upper right corner. Press that and you will find a Property id in the upper right corner – KimHafr Jul 03 '18 at 13:37
  • see also https://stackoverflow.com/a/51259455/132438, for a handy migration script – Felipe Hoffa Jul 10 '18 at 07:30

1 Answers1

0

I guess that you used the script they sent you for importing from Firebase. This is a known issue, and in some cases the script breaks the schema and that's probably why you are getting those null values.

I would recommend to reach Firebase Support [1] and they will help you solve this.

EDIT: I saw this other question posted and answered by a Googler that may be of help [2]

Iñigo
  • 2,500
  • 2
  • 10
  • 20