Reducing BigQuery Costs: How We Fixed a $1M Query Posted by baysienbob on Thursday November 03, 2022 @04:01PM from the shopify.engineering dept. https://shopify.engineering/reducing-bigquery-costs ( 2 comments | on HN )
And it would probably execute faster... :)
(Disclaimer: I work at ClickHouse)