Using STRUCTS for quick analysis in BigQuery


1 min read

I've posted earlier about STRUCTS in BigQuery, here's how I use it from time to time to help me debug and analyze data a bit faster.

Since changing filter values for different test cases / observations you are interested about can be a headache (especially if you have a lot of columns), you could put them in a tuple of STRUCTS and check the matching records at once.

Not a game changer but makes life a bit easier ๐Ÿ˜

No alt text provided for this image

Found it useful? Check out to my Analytics newsletter at