ClickHouse source code is published under the Apache 2.0 License. Software is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

logo_without_text.svg

Stay informed on feature releases, product roadmap, support, and cloud offerings!

Subscribe to our newsletter

icon-github.svg

icon-slack.svg

icon-telegram.svg

icon-twitter.svg

Join the ClickHouse conversation on

ClickHouse

ClickHouse Cloud

Download

PRODUCT

Documentation

Training

Support

Comparison

Use cases

RESOURCES

Blog

Our story

Careers

Contact us

News and events

COMPANY

Learn how DoorDash uses ClickHouse to monitor TCP and DNS traffic helping their observability team take care of their kubernetes infrastructure. This talk is presented by Patrick Rogers, a staff software engineer on the observability team.

Come join us at one of our amazing meetup groups, this presentation is from our San Francisco meetup on December 12th:


Patrick Rogers, a staff software engineer

ClickHouse at DoorDash

Presented by Daniel Muino Software Engineer @ Netflix, at our Los Gatos Meetup at the Netflix Theater. See how Netflix stores Petabytes a day of operational logs with reasonable cost, and lightning fast query speed using ClickHouse.

Come join us at one of our amazing meetup groups, this presentation is from our San Francisco meetup on March 12th:
https://www.meetup.com/clickhouse-silicon-valley-meetup-group

#programming #clickhouse #database #observability  #logs

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse


ClickHouse at Netflix

This presentation is from Alexey Milovidov

Come join us at one of our amazing meetup groups, this presentation is from our Seattle meetup
https://www.meetup.com/clickhouse-seattle-user-group/

#programming #clickhouse #database

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse

Presented by  Alexey Milovidov Founder @ ClickHouse

Building Analytics Applications on ClickHouse

Presented by  Alexey Milovidov


Come join us at one of our amazing meetup groups, this presentation is from our San Francisco meetup on March 12th:
https://www.meetup.com/clickhouse-silicon-valley-meetup-group

#programming #clickhouse #database 

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse

Presented by  Clemens Rawert Cofounder @ Langfuse, at our Los Gatos Meetup at the Netflix Theater. See how Langfuse is using ClickHouse in their V3!
Deck is here: https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-losgatos/Clickhouse%20Meetup_%20Langfuse%20.pptx

Come join us at one of our amazing meetup groups, this presentation is from our San Francisco meetup on March 12th:
https://www.meetup.com/clickhouse-silicon-valley-meetup-group

#programming #clickhouse #database #ai 

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse


Langfuse ClickHouse Meetup

Come learn more about MooseJs here on github 
https://github.com/514-labs/moose
This presentation is from Nicolas Joseph

Come join us at one of our amazing meetup groups, this presentation is from our Seattle meetup
https://www.meetup.com/clickhouse-seattle-user-group/

#programming #clickhouse #database

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse

ClickHouse Meetup Seattle FiveOneFour

This presentation is from Sam Lijin & Vaibhav Gupta 

Come join us at one of our amazing meetup groups, this presentation is from our Seattle meetup
https://www.meetup.com/clickhouse-seattle-user-group/

#programming #clickhouse #database

Don't forget to give us a ⭐ on Github! https://github.com/clickhouse/clickhouse

ClickHouse Seattle Meetups Boundary ML

As AI becomes a driving force behind innovation, building applications that seamlessly integrate AI capabilities with existing data infrastructures is critical.

In this session, we explore the creation of agentic applications using ClickHouse and LangDB. We will introduce the concept of an AI gateway, explaining its role in connecting powerful AI models with the high-performance analytics engine of ClickHouse. By leveraging LangDB, we demonstrate how to directly interact with AI functions as User-Defined Functions (UDFs) in ClickHouse, enabling developers to design and execute complex AI workflows within SQL.

Additionally, we will showcase how LangDB facilitates deep visibility into AI function behaviors and agent interactions, providing tools to analyze and optimize the performance of AI-driven logic. Finally, we will highlight how ClickHouse, powered by LangDB APIs, can be used to evaluate and refine the quality of LLM responses, ensuring reliable and efficient AI integrations.

The slides can be found at https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-singapore/Talk%203%20-%20LangDB%20-%20Singapore%20meetup_25Feb25.pdf

From SQL to AI: Building Intelligent Applications with ClickHouse and LangDB

At Real Estate Analytics (REA), we leverage ClickHouse to power real-time AI and analytics at scale. This talk will cover two key features: parallel extraction and parsing of webpages via S3, which accelerates the processing of large structured and unstructured web data, and slicing and dicing with primary keys and projections, enabling fast, flexible querying for AI models and business intelligence. Combined with our expertise in data science and machine learning, these capabilities drive our products—market insights, RealAgent suite (for agents), and RealInsight (for developers, investors, and institutional clients)—offering end-to-end solutions for informed decision-making. This talk will showcase real-world use cases, performance optimisations, and lessons learned in scaling ClickHouse for AI-driven real estate analytics.

The slides can be found at https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-singapore/Talk%202%20-%20Real%20Estate%20Analtyics%20-%20Singapore%20Meetup_25Feb25.pdf

Yi Sam Lee, Data Lead at Real Estate Analytics

Real-Time Data Intelligence for Real Estate Analytics

Follow our team's recent journey adopting ClickHouse to tackle growing analytics challenges in our Test Engine platform. I'll discuss the customer and data challenges that pushed us to explore new solutions, why we chose ClickHouse, and our early experience with the ClickHouse Cloud platform. While we're still in the early stages, I'll share some practical insights from our onboarding process that could benefit teams considering similar paths.

Buildkite's early adventure with ClickHouse in Test Analytics

Kami’s new clickstream database (discussed in Jordan’s talk) was set to open a new world of product analytics. But to make the most of it, it would need to be integrated with other data from production databases. In this talk, Chuan-Zheng will explain how Kami’s data infrastructure evolved over time to facilitate the company’s growing analytics needs. This includes connections from PostgreSQL and CockroachDB to ClickHouse, how ClickHouse works with some major data use cases, as well as how queries for key metrics such as monthly active users have changed to keep up as Kami’s data warehouse grew from 4 TB to over 200 TB.

The evolution of Kami’s data infrastructure

Kami's in-house analytics system collects clickstream data for 45 million users, reaching 300 GB per day and over 200 billion total data points. This data, ingested into the company’s data warehouse, informs key business decisions, such as product roadmaps, sales planning, and marketing. With Kami’s explosive growth, we have successively rearchitected our data infrastructure to allow for massive scale. In this talk, Jordan will explain how user activity data from Kami’s web app moves through Ruby on Rails, Sidekiq, Kafka, and an in-house Kafka consumer before real-time ingestion into ClickHouse.

Ingesting clickstream data from 45M users into ClickHouse

Modern distributed systems generate diverse operational data across logs, metrics, traces, and events, often siloed in separate tools. This talk delivered live at the Mumbai meetup on February 1 introduces a unified telemetry data platform that brings these observability signals together into a single pane of glass. Aditya Godbole, CTO of Last9, explored the architecture needed to ingest, process, and correlate heterogeneous telemetry data at scale, demonstrating how this unified approach enables powerful cross-signal analysis and faster incident response. Through real-world examples, he discussed both the benefits and challenges of building such a platform, including data modeling, storage optimization, and query performance.

The slides can be found at https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-mumbai-1/Talk%202%20-%20Last9_Mumbai%20Meetup.pdf

The telemetry data platform: Breaking Down Operational Silos

本講演では、クラウドサーカス社が自社のCMS「BlueMonkey」において、ClickHouseを活用してCloudFrontのログ分析を効率化し、コスト削減を実現した事例をご紹介します。 従来、Athenaを用いていたログ分析において、データ量の増加に伴う処理時間の延長とコスト増大が課題となっていました。 これらの課題を解決するため、ClickHouseを導入し、ログの取り込みから分析までのプロセスを最適化しました。 具体的なテーブル設計やログ取り込み手法、そして自動化のアプローチについて解説します。
 
 プレゼンテーションの言語は日本語です。スライドはこちらからご覧いただけます: https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-tokyo-1/Talk%203%20-%20Cloud%20Circus%20-%20Tokyo%20Meetup_23Jan25.pdf
 
 ____________
 
 In this presentation, we will introduce how Cloud Circus leveraged ClickHouse to optimize CloudFront log analysis in its proprietary CMS, "BlueMonkey," achieving improved efficiency and cost reduction.

Previously, log analysis was conducted using Athena, but as the data volume increased, longer processing times and rising costs became major challenges. To address these issues, ClickHouse was implemented to optimize the entire process from log ingestion to analysis.

We will provide insights into table design, log ingestion methods, and automation approaches used in this implementation.

The presentation is in Japanese. Slides can be found here: https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-tokyo-1/Talk%203%20-%20Cloud%20Circus%20-%20Tokyo%20Meetup_23Jan25.pdf

クラウドサーカス株式会社 クラウドエンジニア Geek Headquarters, テクニカルグループ, インフラセクション, 朱 九霖（しゅ きゅうりん）
Shu Kurin, Cloud Engineer Geek Headquarters, Technical group, Infra section at Cloud Circus, Inc.

ClickHouse導入によるCloudFrontログ分析の高速化とコスト削減  Accelerating CloudFront log analysis and reducing costs

ストレージソリューションの導入やリプレイスには、複雑で長期にわたる作業がつきものです。本セッションでは、私たち LINE Manga のチームが、すでに確立された分析パイプラインと競合させることなく スタンドアロン／ステートレスな ClickHouse サーバー を既存エコシステムへシームレスに組み込んだ事例をご紹介します。

具体的には、水平方向・垂直方向にシャーディングされた多数の MySQL クラスターに対して、リアルタイムかつアドホックな分析を ClickHouse で実装しました。複数シャードを JOIN するカスタム Script 開発と比較して、SQL で完結するため柔軟なデータ探索が可能となり、いまや ClickHouse は不可欠なツールへと進化しました。

もし部分的または段階的に ClickHouse を導入したいとお考えであれば、このセッションはよいヒントになると思います。これを見たあとは、きっと clickhouse-local を自分の開発でも使ってみたくなると思います。

プレゼンテーションの言語は日本語です。スライドはこちらからご覧いただけます: https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-tokyo-1/Talk%202%20-%20LINE-Digital-Frontier%20-%20Tokyo%20Meetup_23Jan25.pdf

____________

Introducing or replacing a storage solution is often a complex and long-term process. In this session, we will share how our LINE Manga team seamlessly integrated a standalone, stateless ClickHouse server into our existing ecosystem without disrupting an already established analytics pipeline.

Specifically, we implemented real-time and ad-hoc analytics using ClickHouse on numerous MySQL clusters that are sharded both horizontally and vertically. Compared to developing custom scripts for joining multiple shards, leveraging SQL within ClickHouse allowed for more flexible data exploration, ultimately transforming ClickHouse into an indispensable tool for our operations.

If you're considering a partial or phased adoption of ClickHouse, this session will provide valuable insights. By the end, you might even be eager to try out clickhouse-local in your own development workflow!

The presentation is in Japanese. Slides can be found here: https://github.com/ClickHouse/clickhouse-presentations/blob/master/2025-meetup-tokyo-1/Talk%202%20-%20LINE-Digital-Frontier%20-%20Tokyo%20Meetup_23Jan25.pdf

LINE Digital Frontier 株式会社, Senior Software Engineer, Tech Lead, 松田一樹
Kazuki Matsuda, Senior Software Engineer, Tech Lead at LINE Digital Frontier Corporation

Videos

Products

Resources

Company

Join our community

Comparisons

Partners