I've worked at a number of companies using Clickhouse and they all self-hosted. I imagine Clickhouse corporate is focused on large customers.

My understanding is that those 2,000 represent some very large and enterprise-y contracts. The GitHub itself has almost 2,000 contributors: https://github.com/ClickHouse/ClickHouse

the ACV for a data warehouse is orders of magnitude beyond $200. Snowflake's ACV is something like $300k/yr

we use smallest cluster and it's $450/month, most companies probably pay much more.