BigQuery Optimization Strategies 3: Table Flattening
About Exploding Tables and Imploding Arrays
Published in
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.