Nguyen Pham

New #BigQuery #UNION is resilient to column changes

Schema new columns no longer require code change with LEFT UNION ALL BY NAME.

n-pham.github.io/blog/posts/b...

BigQuery Pipe syntax is the end of Subquery Madness

Since the pipe operator |> WHERE can see every alias that exists --> no more subquery just to reference a previous expression

n-pham.github.io/blog/posts/b...