Nerd For Tech
Published in

Nerd For Tech

Working with Nested and Repeated Fields in BigQuery

The What, Why, and How of BigQuery Nested and Repeated Data. By Fassil S. Yehuala and Sanyukta Suman

Photo by József Koller on Unsplash

What is Nested data?

Why Nested and Repeated Fields?

Normalized Schema
Fully Denormalized Schema
Denormalizing Data with Nested and Repeated Fields
STRUCTs in BigQuery Schema
ARRAYs in BigQuery Schema

When to Use Nested and Repeated Fields?

How to Create Nested and Repeated Fields?

How to Query Nested and Repeated Fields?

Conclusion

Further Links

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
datadice

Data Analytics Boutique, based in Coburg, DE. Building modern, customized and cloud-based data warehouse solutions. https://www.datadice.io/