BigQuery UNNEST: How to work with nested data in BigQuery

We use a common example: un-nesting Firebase event data to facilitate data science analysis

Image licensed to author

We frequently apply machine learning techniques to event-based data in order to generate high-value insights; from predicting customer churn using people’s recent activity of say, a subscription-based product, to…