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.