Nguyen Pham
@n-pham.bsky.social
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...
Schema new columns no longer require code change with LEFT UNION ALL BY NAME.
n-pham.github.io/blog/posts/b...
February 9, 2025 at 11:18 AM
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...
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...
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...
February 6, 2025 at 11:59 AM
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...
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...