hey you can create pivot tables by BigQuery without paid GSuite subscription at all, this is possible with SeekTable (this is free BI tool): https://www.seektable.com/help/bigquery-pivot-table