Pretty much everything I threw at both, Clickhouse did fatter. I never benchmarks write speeds properly, but I do know CH is capable of high write performance.

Pretty much everything I threw at both, Clickhouse did fatter. I never benchmarks write speeds properly, but I do know CH is capable of high write performance. General analytics queries for the like of dashboards, CH latencies in the order of < 100ms, Snowflake about a second. Snowflake couldn’t do Geospatial queries when I had to use it, but I was getting responses from CH in like 40ms for a dataset of 10’s millions of points. This guy has done some really in depth benchmarks: https://tech.marksblogg.com/billion-nyc-taxi-clickhouse.html https://tech.marksblogg.com/billion-nyc-taxi-clickhouse.html And https://tech.marksblogg.com/benchmarks.html https://tech.marksblogg.com/benchmarks.html CH is one of the fastest non-GPU databases there.