Photo by Marlon Maya on Unsplash

Pivot and Unpivot Functions in BigQuery For Better Data Manipulation

A detailed tutorial

Pivot is a very simple function in BigQuery that can be very useful when you need to rotate rows into columns. It uses an aggregate function on rows and converts the categories in rows to columns. There is unpivot function that does totally an opposite operation. If you are a big query user in Google Cloud Platform…