BigQuery Optimization Strategies 3: Table Flattening

About Exploding Tables and Imploding Arrays

Martin Weitzmann
Towards Data Science
9 min readFeb 1, 2023

--

Arrays are one of the coolest features for an analytics databases you can think of, because it can store additional information right at the place and time it happened. Let’s explore some basic examples and then have a look at arrays in Google Analytics 4.

Photo by Torsten Dederichs on Unsplash

--

--