Reducing BigQuery Costs: How We Fixed a $1M Query (shopify.engineering)

Interesting read. What are some other tips?

You should try it on ClickHouse Cloud - the pricing is not based on bytes, so the resulting cost would be near zero compared to $1M on BigQuery.

And it would probably execute faster... :)

(Disclaimer: I work at ClickHouse)