User stories
Discover how companies are using ClickHouse to speed up their workloads and lower costs.
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
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
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
Real-time analytics
Fast answers in cancer research
“What was taking 2 minutes now takes literally half a second.”
Highlight
Real-time analytics
Funnel analytics and distributed queries in ClickHouse
Learn how Klaviyo uses ClickHouse in this meetup recording.
Highlight
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
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.”
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.“
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.”
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.”
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“
Real-time analytics
From minutes to seconds: How Skool’s migration from Postgres to ClickHouse transformed their analytics
"We went from minutes for analytic queries down to seconds without really any optimization effort at all."
Jason Anderson, Head of Data
Real-time analytics
SIEM made simpler: How Huntress improved performance and slashed costs with ClickHouse
“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
Real-time analytics
Speed meets scale: How ClickHouse helps Tydo deliver lightning-fast customer analytics
“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
Logs, events, and traces
Building Chronicle: How Temporal supercharged their observability with ClickHouse
“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
Real-time analytics
Helping teams scale AI development
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
Machine learning and GenAI
From Rockset to ClickHouse: How Lens made its database faster and more efficient
"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."
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.
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.”
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.”
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”
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.”
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”
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.”
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.”
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.”
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.
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.
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
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.
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.
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.”
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.”
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.”
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.”
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.”
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.”
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.”
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.”
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.“
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”
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.“
Machine learning and GenAI
Query times improved 10x with ClickHouse
“After Testing Hadoop and Spark, We Chose ClickHouse“
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.”
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.”
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”
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.”
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.”
Products
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2024 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.