[Wranglers] Google BigQuery adds support for GROUP BY ALL

[Ali, Saqib]

Google BigQuery now supports GROUP BY ALL clause. This clause infers groups
by excluding:

1) expressions that are aggregate functions e.g. avg(), sum()
2) expressions that are windowing functions. e.g. COUNT(*) OVER ()

Support for GROUP BY ALL was also added to Snowflake late last year. I have
been using it quite frequently in Snowflake, especially for adhoc
exploratory queries. It makes writing exploratory queries a lot faster.

Sincerely,
Saqib
https://qosf.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20240306/5d0e340e/attachment.htm>