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 & 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, & 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
Logs, Events, & 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.”
Highlight
Logo
Real-time Analytics
Closing the breach window, from data to action
“QRadar Log Insights uses a modern open-source OLAP data warehouse, ClickHouse, which ingests, automatically indexes, searches and analyzes large datasets at sub-second speed. You get near real-time visibility and insights from your ingested data.”
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, & 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, & 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
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, & 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, & 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, & 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 & GenAI
Query times improved 10x with ClickHouse
“After Testing Hadoop and Spark, We Chose ClickHouse“
Logo
Machine Learning & 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 & 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, & 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.”
Follow us
Twitter imageSlack imageGitHub image
Telegram imageMeetup imageRss image
© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.