SQL Pro tips : GCP BigQuery SQL CROSS JOIN with UNPIVOT UNNEST
Introduction   TL;DR : Why to use UNPIVOT over UNION ALL ? Performance, UNION ALL scans all...
Tags: gcp, sql, database, bigdata