How to Pivot in Google BigQuery

Using the Pivot Function in BigQuery SQL

Photo by Zetong Li on Unsplash

The pivot table is a special type of table that can be used to structure, summarize and analyze data that is available in tabular form with little effort, without changing the source data [1]. As in the example below [2], you can use pivot tables to easily display data based on quarters — but of course other metrics are also possible. This…