User stories

“ClickHouse plays a pivotal role as a key component in both Instana and QRadar. IBM has deployed hundreds of ClickHouse servers across its various product offerings.”

“There's that feeling of new tech where everything just feels like it's going right. Can we get the data in there quick enough? Yes. Can we query the data in a way that is going to have a responsive UI? Yes. Is the cost gonna kill us? No.“

“At Sony LIV, we ingest tens of millions of video streaming events into ClickHouse Cloud and run queries to generate complex dashboards for analysis. This allows our operations team to monitor, alert & troubleshoot the QOS and QOE of our customers in real-time. ClickHouse Cloud has helped us to optimize costs and ensure the high availability and resilience of our services.”

“ClickHouse helps us efficiently and reliably analyze logs across trillions of Internet requests to identify malicious traffic and provide customers with rich analytics.”

“What was taking 2 minutes now takes literally half a second.”

Learn how Klaviyo uses ClickHouse in this meetup recording.

“How do we move beyond prompting as guesswork, and start treating it like real programming, so we can build pipelines that are reliable not just in our code, but in our data too? That’s BAML. And it would only have been possible with ClickHouse.” Vaibhav Gupta, Founder and CEO

“We need our platform to operate in real time. The moment we detect suspicious activity, we aim to block the API user before they can attack the site or exploit a vulnerability.” - Slava Yudanov, VP of Engineering, Wallarm

"If we are looking at high-performance database systems for these types of workloads, the only two options are ClickHouse and Snowflake. ClickHouse is significantly faster." - Martijn Witteveen, CEO

"We don’t want to manage infrastructure or build our own data warehouse. For us, that’s where ClickHouse comes in. It’s an integral part of our solution today." Aditya Godbole, CTO

"With ClickHouse Enterprise Edition, we’ve turned our biggest data challenges into opportunities—achieving write speeds of up to 20 million rows per second and reducing infrastructure costs by 60%." Poizon

"Since adopting ClickHouse, we’ve been able to iterate on ML workloads 5-10x faster than with Spark or Teradata-based solutions, thanks to the faster compute performance and the ability to consolidate data in one location. User feedback has been overwhelmingly positive, particularly among researchers."

"On our security team, we like to say that if we do our jobs well, we let the brilliant people at Harvey do their jobs, and we all get to drink Mai Tais on the beach. ClickHouse helps us do just that." Mike Parowski, Detection & Response

"By migrating to ClickHouse and unifying our data storage technology stack, we have optimized real-time market data storage with 4x reduction in costs, a 10x improvement in write performance, and dramatically simplified our architecture—reducing data management complexity by 128x while enhancing query efficiency by over 300%." Wenquan Liu, Longbridge Technology

“ClickHouse Cloud has been great to work with. Managing it is super easy -- we hardly have to think about it, and their team has been very helpful and responsive.” Julian LaNeve, CTO, Astronomer

"ClickHouse makes a lot of sense for what we’re trying to do. It lets us work faster, think bigger, and focus on what we care about most — scaling intelligence through AI." - Eiso Kant

"We freed up half the time of two engineers, saved a lot of stress, and shifted our focus from maintenance to creation and more interesting tasks."

BigQuery was 2x more expensive due to its pricing model that charges based on bytes scanned, and Cloud Spanner was 6x more expensive for the workload they tested. Adevinta chose ClickHouse Cloud as the winner, as it fit within their budget and offered the most value for their needs.

Deutsche Bank has using ClickHouse since 2017 as an internal data warehouse to store trade data, market data, and expose it to data scientists, traders, and quants.

“ClickHouse is the center of our data strategy. It’s really fast and cost-efficient, but most importantly it connects to everything. Data science as a discipline is not like engineering, where you can build in phases methodically. Iteration time is incredibly key to a data science team workflow.”

"Rokt looked into other databases that could provide better support, since they faced difficulties with Elasticsearch. They evaluated several alternatives, including Apache Pinot, Druid, Citus Data, StarRocks, Snowflake and selected ClickHouse."

"ClickHouse gives us data analytics capabilities that grow with our needs, while keeping costs low and predictable." Andi Pangeran, Principal Software Engineer

"ClickHouse Cloud has been awesome for us. We’ve been able to create reproducible ClickHouse instances across all of our environments — dev, test, staging, production, you name it — all in a single click." "Clickhouse Cloud has awesome monitoring and automatic updates, so you never get stuck with a database version that’s three years out of date." Chris Lawrence, Senior Software Engineer

"After comparing against Snowflake, Firebolt, Amazon Redshift, Amazon Aurora (Postgres), we found that for our specific workload, ClickHouse Cloud provided both the best performance, and best value for money. More subjective criteria (where differences between implementations in each service make direct comparisons difficult), such as monitoring, HA/DR, scaling etc. also scored highly for ClickHouse Cloud." Jonathan Hill, Vice President Of Engineering

"ClickHouse supports OpenTelemetry, which is awesome for tracing performance. It lets us dive into ClickHouse and not only capture flows through our distributed systems, but also track how those calls are executed within ClickHouse, giving us clear visibility." Joshua Hildred, Software Developer, IBM Instana

"With ClickHouse Cloud, we’re currently handling around a billion records, and we’ve maintained the same sub-second performance benchmarks we achieved in our previous setup with much smaller datasets." Navaneet Krishna, Lead Data Analyst

"ClickHouse is the fastest database in the world. You can’t argue with that." Aditya Patadia, Co-Founder and CEO

“With ClickHouse, what used to be days and days and days of work, can now be done very quickly.” Cayden Meyer, Founder and CEO

“We knew that moving to one database like ClickHouse would make our system more performant and scalable, without breaking the bank.” Larry Finn, Principal Engineer

"We went from minutes for analytic queries down to seconds without really any optimization effort at all." Jason Anderson, Head of Data

“There’s zero maintenance required [for ClickHouse]. We ingest a ton of data, it’s super efficient and way cheaper than other solutions. It checks all the boxes.” Chris Bisnett, Co-Founder and CTO of Huntress

“One of the reasons we were so excited to use ClickHouse is it’s just so much faster than other databases.” “ClickHouse allows us to provide really fast analytics to our customers, which is exciting and something we couldn't get with our earlier database options.” Manav Kohli, Co-Founder & CTO

“As Charity Majors says, ‘Observability isn’t just about understanding bugs and outages; it’s about proactively understanding our software and how users are experiencing it.’ We’re able to do that through the raw data we collect and query efficiently thanks to ClickHouse.” Sean Gillespie, Staff Software Engineer

We’ve loved working with ClickHouse. The product is great, the architecture has been super easy to set up, and the low latency and scalability are amazing.” ~ Lukas Biewald, CEO, Weights & Biases

"ClickHouse’s ability to handle a high volume of concurrent queries without performance degradation is another big advantage. Unlike Rockset, where query limits hindered Sree’s work and led to frustrating bottlenecks, ClickHouse allows the team to scale their ML operations as Lens Protocol grows."

“The objective was to build a new system from the ground up, to scale not only beehiiv’s data platform, but ideally the business as a whole,” Eric says.

“We’re a company that tries to ingest as much data as possible to make optimization decisions, which can be a recipe for rising costs,” Marco says. “ClickHouse Cloud makes that process so efficient, and the price point is so much lower, we can actually look forward to ingesting more data into our systems while keeping costs relatively at bay.”

“Compared to other solutions we explored and what we had before, ClickHouse just blows them away,” Zeev says. “It’s very, very cheap, and the quality is extremely high.”, Zeev Feldbeine, Principal Data Engineer at Vimeo

“At Coinhall, managing vast amounts of blockchain data efficiently is crucial for our consumer-facing trading platform. Initially, we used BigQuery, but as our data grew, so did its costs and performance issues. After exploring several alternatives, we found ClickHouse to be the clear winner. ClickHouse significantly outperformed other databases we tested like Snowflake, Rockset, and SingleStore, and delivered at 40x cost savings.”

“The system manages to store over 10 billion rows spanning four years in less than 325 GB on disk”

“The query performance was just blazing fast. I couldn't believe it. I had to go back a couple of times just to make sure I was querying it properly.”

“When you’re doing interactive analysis of an AI product, an engineer can’t run something and then wait for five minutes”

“ClickHouse has proved to be a game-changer, propelling us towards greater efficiency and effectiveness in managing our data infrastructure.”

“ClickHouse looked good for their use case of supporting 10-million-member records with 100 fields each: We had a billion rows to store.”

“Adopting ClickHouse has enhanced our data analytics capabilities, supporting the growing demands of our internal teams efficiently and cost-effectively.”

OpenMeter team has developed a scalable, robust metering system capable of handling millions of billable events per second, built on top of ClickHouse Cloud.

Trip.com migrated from Elasticsearch and built a 50PB logging solution with ClickHouse. Storage space savings exceeded 50%, enabling the existing Elasticsearch servers to support a 4x increase in data volume with ClickHouse. Query speed is 4 to 30 times faster than ElasticSearch, with a P90 of less than 300 ms and a P99 of less than 1.5s.

“We want to be able to handle a wide variety of different data pipelines and code tasks. Ultimately, the goal is to enable whatever deployment and trigger patterns developers, data engineers, platform engineers, and software engineers need,” and this is why ClickHouse has become integral to Prefect

In this talk -- given at the ClickHouse NYC Meetup on April 26, 2023 -- Brooke McKim (Co-founder and CTO of Vantage) shares their journey from Redshift to ClickHouse Cloud.

“As we became more popular, we began ingesting millions of events every minute. Our rudimentary Postgres-only stack—which had served us well in the early days—wasn’t cutting it.”

“The benefits were immediate, with faster data processing and accurate analytics that allowed me to make strategic decisions with confidence. ClickHouse opened new horizons for the growth and success of my company, raising our executive vision to levels never reached before.”

“We evaluated more than a dozen different big data systems before settling on ClickHouse. No system comes close to ClickHouse when it comes to the flexibility ClickHouse provides.”

“With ClickHouse, the data pipeline logic is simplified, and is only dealing with the “streaming” aspect of the write as opposed to all of these complexities. ClickHouse thus enables a simpler write design pattern just like any other new age data lake systems like Hudi etc. but with a more simplistic developer experience.”

“We use ClickHouse Cloud to monitor millions of real-time web performance data points, to ensure we’re getting faster all the time. The platform delivers fast and reliable data management, while also proving to be cost efficient and user-friendly.”

“Moving from Elasticsearch to ClickHouse was a long journey, but this is one of the best tech decisions we ever took.”

“With dbt execution orchestrated in various intervals, we can also leverage ClickHouse for internal BI use cases. We’ve found this setup very practical, as we can flexibly create new analytical views of our customer data without moving it from our production operational systems.”

“With Snowflake, we were using the standard plan, small compute, which cost nearly six times more than ClickHouse Cloud. We got several seconds query time and no materialized views. With ClickHouse Cloud’s production instance, we are getting sub-second query time along with materialized views. The decision to switch was a no-brainer for us.”

“When we tested how much time the same reports would take with ClickHouse, people were amazed. We ran the same data, and in a blink of an eye, we had the results.“

“ClickHouse solves most of our problems very efficiently at a small fraction of the price in terms of infrastructure. This is a far better advantage for us in our books”

“We collect tens of thousands of data points from customers’ phones and other more traditional sources. ClickHouse is used as a way to process all of these SMS messages and extract valuable information used for the scoring and fraud models.“

“After Testing Hadoop and Spark, We Chose ClickHouse“

“We aggregate the user’s history in ClickHouse and use it as a data store for training and inference. Even when reading 10s of millions of rows, the performance was very nice and not the bottleneck when training new models.”

“ClickHouse was perfect as Big Data Storage for our ML models.”

“ClickHouse’s performance exceeds all other column-oriented database management systems. It processes billions of rows and tens of gigabytes of data per server per second”

“Migrating logs from Elasticsearch to ClickHouse has not only significantly reduced storage costs but also provided us with a faster querying experience.”

“In the post-evaluation of each database against our criteria (with metrics ranging from query performance to cost), ClickHouse emerged as the unrivalled frontrunner. It excelled across the board, even astonishingly so in certain domains, and proved more cost-efficient.”