Going to re:Invent this December? Come party with us and The Chainsmokers ->->

User stories

Discover how companies are using ClickHouse to speed up their workloads and lower costs.

Logo
Real-time analytics
Real-time fraud detection
“ClickHouse is a fast and highly performant analytical database, widely used across Instacart to power other use-cases such as critical retailer and ads dashboards, calculating results for A/B testing, and machine learning signals.”
Highlight
Logo
Machine learning and GenAI
When you're in the database space, it's hard not to hear about ClickHouse!
“We’ve had a positive experience with ClickHouse. It allowed us to scale LangSmith to production workloads and provide a service where users can log all of their data. We couldn’t have accomplished this without ClickHouse.”
Highlight
Logo
Logs, events, and traces, Real-time analytics
How Lyft cut infrastructure costs using ClickHouse
“We needed something to slice and dice real-time data, like rides and driver hours across cities and regions where Lyft runs. Using ClickHouse resulted into a lot of performance benefits for us with huge cost savings for the org.”
Highlight
Logo
Real-time analytics
Fast answers in cancer research
“What was taking 2 minutes now takes literally half a second.”
Highlight
Logo
Real-time analytics
Funnel analytics and distributed queries in ClickHouse
Learn how Klaviyo uses ClickHouse in this meetup recording.
Highlight
Logo
Real-time analytics
Behind the scenes: How ClickHouse helps Vimeo power video analytics at scale
“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
Highlight
Logo
Real-time analytics
Closing the breach window, from data to action
“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.”
Logo
Real-time analytics
10x Cost Reduction: Clearbit's Postgres to ClickHouse Cloud Migration
“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.“
Logo
Logs, events, and traces
Sony LIV ingests tens of millions of video streaming events
“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.”
Logo
Logs, events, and traces
6M requests per second using ClickHouse
“ClickHouse helps us efficiently and reliably analyze logs across trillions of Internet requests to identify malicious traffic and provide customers with rich analytics.”
Logo
Real-time analytics
Vantage Cuts Costs 50%
“Moving over to ClickHouse we were able to cut that (Redshift) bill in half … That 30 second query now takes a couple seconds or under a second under a second … every page loads just faster“
Logo
Real-time analytics
The story of beehiiv’s journey from Postgres to ClickHouse
“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.
Logo
Real-time analytics
Measuring brand impact: LoopMe & ClickHouse Cloud drives better advertising outcomes
“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.”
Logo
Real-time analytics
Trade secrets: How Coinhall uses ClickHouse to power its blockchain data platform
“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.”
Logo
Logs, events, and traces, Real-time analytics
Corsearch replaces MySQL with ClickHouse for content and brand protection
“The system manages to store over 10 billion rows spanning four years in less than 325 GB on disk”
Logo
Logs, events, and traces
Scaling Graphite with ClickHouse
“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.”
Logo
Real-time analytics, Machine learning and GenAI
Building Better AI Products, Faster: How Braintrust Uses ClickHouse for Real-Time Data Analysis
“When you’re doing interactive analysis of an AI product, an engineer can’t run something and then wait for five minutes”
Logo
Logs, events, and traces
Tekion slashed their storage needs from 27TB to just 2.5TB in two months.
“ClickHouse has proved to be a game-changer, propelling us towards greater efficiency and effectiveness in managing our data infrastructure.”
Logo
Real-time analytics
ClickHouse replaces Postgres to power real-time analytics
“ClickHouse looked good for their use case of supporting 10-million-member records with 100 fields each: We had a billion rows to store.”
Logo
Logs, events, and traces
ClickHouse has become the backbone for all of our data applications
“Adopting ClickHouse has enhanced our data analytics capabilities, supporting the growing demands of our internal teams efficiently and cost-effectively.”
Logo
Real-time analytics
Before ClickHouse, OpenMeter had architecture that was expensive and difficult to maintain
OpenMeter team has developed a scalable, robust metering system capable of handling millions of billable events per second, built on top of ClickHouse Cloud.
Logo
Logs, events, and traces
Building a 50PB logging solution with ClickHouse
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.
Logo
Logs, events, and traces, Real-time analytics
Event-driven workflow orchestration powered by ClickHouse
“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
Logo
Real-time analytics
Our Journey from Redshift to ClickHouse Cloud
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.
Logo
Real-time analytics
Tips & Tricks for ClickHouse Performance
Brooke McKim, CTO Vantage, shares tips and tricks for getting the most out of your ClickHouse performance at NYC Meetup in March 2024.
Logo
Real-time analytics
ClickHouse improved query performance by at least 18x and up to 137x
“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.”
Logo
Logs, events, and traces
Imagine playing your favorite online game with almost no lag
“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.”
Logo
Real-time analytics
We evaluated more than a dozen different big data systems before settling on ClickHouse
“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.”
Logo
Real-time analytics
ClickHouse enables a simpler write design pattern
“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.”
Logo
Real-time analytics
ClickHouse Cloud delivers fast and reliable data management
“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.”
Logo
Real-time analytics
11x more cost effective and 10x performance improvement
“Moving from Elasticsearch to ClickHouse was a long journey, but this is one of the best tech decisions we ever took.”
Logo
Business intelligence
Building a unified data platform with ClickHouse
“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.”
Logo
Real-time analytics, Business intelligence
6x cost savings when compared to Snowflake
“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.”
Logo
Real-time analytics
Ongage's Strategic Shift to ClickHouse
“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.“
Logo
Real-time analytics
50 Million Daily Payment Transactions in Real-Time with ClickHouse
“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”
Logo
Real-time analytics
Instant in ClickHouse vs forever in Postgres
“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.“
Logo
Machine learning and GenAI
Query times improved 10x with ClickHouse
“After Testing Hadoop and Spark, We Chose ClickHouse“
Logo
Machine learning and GenAI
Even when reading 10s of millions of rows, the performance was very nice
“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.”
Logo
Machine learning and GenAI
Inserting around 100 billion records per day, over 1 million records per second
“ClickHouse was perfect as Big Data Storage for our ML models.”
Logo
Real-time analytics
10s of GBs of data processed per second
“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”
Logo
Logs, events, and traces
Reducing cost by migrating from ElasticSearch to ClickHouse
“Migrating logs from Elasticsearch to ClickHouse has not only significantly reduced storage costs but also provided us with a faster querying experience.”
Logo
Logs, events, and traces
How ClickHouse impacted Vimeo
“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.”
Follow us
Twitter imageSlack imageGitHub image
Telegram imageMeetup imageRss image