A Guide to Arrays and Structs in BigQuery

Learn to work with records and repeated fields

Photo by Kelly Sikkema on Unsplash

I always found SQL frustrating because I couldn’t store lists in a convenient way. Fortunately, modern data warehouses like BigQuery allow us to use arrays and structs. Let’s see how it works and learn to store and query nested data!

Creating arrays and structs