BigQuery: SQL on Nested Data
Published in
7 min readJul 24, 2019
Running analyses in BigQuery can be very powerful because nested data with arrays basically means working on pre-joined tables. Querying them can be very efficient but a lot of analysts are unfamiliar with semi-structured, nested data and struggle to make use of its full potential.
