Articles in this series
What function do you use to explicitly de-duplicate in BigQuery?I normally use ROW_NUMBER(), but I've recently encountered a really interesting blog...
SELECT * is not a good practice in production, but I still use it for spot checks, when debugging, analyzing or validating data - especially when...
I use STRUCTS in #BigQuery quite a bit. One interesting use case for them is for audit purposes a separate column containing metadata about how the...
One of the most common sightings in SQL code is using ranking functions. It's simple but we must surely get it right. I use ROW_NUMBER very often for...
So, if you ever find yourself working with multiple window functions in BigQuery, leverage the named windows specification for tidier, leaner...
Almost everybody knows the usual standard SQL aggregation functions like SUM, MAX or AVG. In this short post, we're going to look at ARRAY_AGG:...