flâneur

In-depth: ClickHouse vs Snowflake - PostHog

posthog.com · 2,320 words · saved by 1 readers

Two years ago, Snowflake versus ClickHouse was a straightforward comparison. Back then, Snowflake was fully managed, expensive, and broadly featured. ClickHouse was on-prem, open source, and speed-optimized. Two ends of a data warehouse spectrum splitting versatility (Snowflake) and speed (ClickHouse). If I was to compare the databases to boats, ClickHouse is a jet ski – ultra-fast, but limited. Snowflake, meanwhile, is a shipyard – a slew of (expensive) tools spanning various functions. But, as I said, that was two years ago. Today, Clickhouse has broken ground on features that compete with Snowflake’s managed solution. Likewise, Snowflake released features that are beginning to tackle ClickHouse’s speed. However, the overlap between ClickHouse and Snowflake remains nascent. Today, they are both still pretty different, though the gaps are closing. Snowflake and ClickHouse are at wildly different stages of growth. Snowflake, founded in 2012, is a well-funded, publicly-traded decacorn w

In-depth: ClickHouse vs Snowflake Mathew Pregasen Feb 15, 2023 Guides , ClickHouse Contents Background What even is Snowflake? What about Clickhouse? Hosted ClickHouse Architecture overview Differences in query optimization & speed Who uses Snowflake and ClickHouse? Conclusion Further reading Two years ago, Snowflake versus ClickHouse was a straightforward comparison. Back then, Snowflake was fully managed, expensive, and broadly featured. ClickHouse was on-prem, open source, and speed-optimized. Two ends of a data warehouse spectrum splitting versatility (Snowflake) and speed (ClickHouse). If

related reading