# Join me if you can: ClickHouse vs. Databricks vs. Snowflake - Part 2

DevFeed: [Join me if you can: ClickHouse vs. Databricks vs. Snowflake - Part 2](<https://devfeed.tech/articles/join-me-if-you-can-clickhouse-vs-databricks-vs-snowflake-part-2-5354.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/join-me-if-you-can-clickhouse-vs-databricks-snowflake-part-2>)

Author: Al Brown; Tom Schreiber

Published: 2025-06-25T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Benchmark](<https://devfeed.tech/topics/benchmark.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [databricks](<https://devfeed.tech/topics/databricks.md>), [datasets](<https://devfeed.tech/topics/datasets.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cost-savings](<https://devfeed.tech/tags/cost-savings.md>), [memory](<https://devfeed.tech/tags/memory.md>), [parquet](<https://devfeed.tech/tags/parquet.md>), [performance](<https://devfeed.tech/tags/performance.md>), [s3](<https://devfeed.tech/tags/s3.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article explains how replacing joins with in-memory dictionaries in ClickHouse Cloud improved query performance by up to 6.6x and reduced costs by over 60% in benchmarks querying 1.4 billion rows. It describes using dictionaries for fast lookups against small dimension tables and reports that the changes required only minor SQL edits, without reloading data or rewriting schemas.

## Source excerpt

We took the same JOIN-heavy benchmark from Part 1 and made ClickHouse even faster. By replacing JOINs with in-memory dictionaries, we saw up to 6.6x faster queries and over 60% cost savings, with no data reloading or schema rewrites required.