Comment by tbragin

For a user perspective, you can also check out this recent blog: https://clickhouse.com/blog/hifis-migration-from-bigquery-to...

TL;DR * HiFi moved because BQ pricing and query latency did not fit the needs for their customer-facing app (music royalty data analytics) * Caveat when moving to ClickHouse: they had to adjust how they handle JOINs

Disclaimer: I also work at ClickHouse.