Firebase BigQuery Schema

[jon.ta...@raise.com]

Greetings,

Is there a source of truth or release notes documenting Firebase's current BigQuery schema?

We export our Firebase data to BigQuery using Firebase's builtin BigQuery integration.  I have been using this support article: https://support.google.com/firebase/answer/7029846?hl=en

I have seen fields added from time to time, but I am unsure where to go to learn more about those fields.  Here's an example:

* We now see the `device.web_info` record on our events tables (e.g. events_20180924), which holds the `browser`, `browser_version`, and `hostname` fields.

* The `device` record itself also has `browser` and `browser_version` fields.  Additionally, there is an `event_dimensions` record with a `hostname` field.

That leads to questions such as...

* Are the fields in the `web_info` record now the source of truth for this information?

* When should we use one over the other?

Thanks!

Jon

CONFIDENTIALITY NOTICE: This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED.