Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
table without updating the query. (Hint: I’m not sure this one is possible in pure-SQL because when I tried, I noticed that BigQuery seems unable to automatically cast NULLs into complex types when performing a union. This might be a nice challenge to do with bigquery-dataframes or bigquery-frames,