How has your experience been? It depends on the use case which obviously differs on a case by case basis where BQ has its advantages vs Clickhouse and the other way around. I am simply curious on which one you went with for what kind of a use case and how your experience was?
I work in ClickHouse, and I do competitive research. Here are my observations:<p>BigQuery bills over uncompressed data ($20/TB/month), and with the typical compression ratio, it is very expensive.
The processing is also very expensive ($5/TB of uncompressed data processed).<p>Every query in BigQuery takes around a second minimum. Subsecond latency cannot be achieved in most cases. However, there is some feature for limited scenarios.<p>It is impossible to insert new data in real-time, and process range queries quickly. Range queries require pre-sorted data to run quickly. No "merge tree" magic like in ClickHouse. This makes real-time analytics and user-facing queries impossible with BigQuery, unlike ClickHouse. You will end up creating daily, hourly, and minute tables in BigQuery, while in ClickHouse, all the data will reside in one big table with no hassle.<p>BigQuery is not as versatile as ClickHouse. It is just an SQL engine, and you won't find many practical features for web analytics, financial data, sensor data, or APM... as in ClickHouse.<p>You cannot set it up on your infrastructure if needed.<p>Advantages of BigQuery:<p>Almost no settings.<p>Queries scale automatically, and the number of workers is selected for every query as needed.<p>Fairly good for long-running queries.