Learn about the latest ClickHouse tips, tricks and company announcements.

ClickHouse now supports granule-level pruning for lightweight projections, enabling them to act as true secondary indexes that work together to dramatically speed up multi-filter queries without duplicating full table data.

large_3.png

medium_3.png

small_3.png

thumbnail_3.png

3.png

ClickHouse projections now behave like true secondary indexes

“With ClickHouse, we saw a whopping 88% reduction in storage, and P99 queries dropped from 6+ seconds to less than 200 milliseconds.” - Pragnesh Bhavsar, Staff Engineer

large_HighLevel User Story Issue 1216.png

medium_HighLevel User Story Issue 1216.png

small_HighLevel User Story Issue 1216.png

thumbnail_HighLevel User Story Issue 1216.png

HighLevel User Story Issue 1216.png

How HighLevel rebuilt its data platform for speed, scale, and simplicity on ClickHouse Cloud

ClickHouse now streams secondary index evaluation alongside data reads instead of scanning indexes upfront, making index usage incremental and demand-driven, reducing startup latency, unnecessary work, and memory usage.

large_2.png

medium_2.png

small_2.png

thumbnail_2.png

2.png

Streaming secondary indices: incremental, demand-driven index evaluation

From 30 seconds to 0.5 seconds — the story of how we made ClickHouse fly on in-memory data

large_Journey to Zero-Copy Blog Post.jpg

medium_Journey to Zero-Copy Blog Post.jpg

small_Journey to Zero-Copy Blog Post.jpg

thumbnail_Journey to Zero-Copy Blog Post.jpg

Journey to Zero-Copy Blog Post.jpg

The Journey to Zero-Copy: How chDB Became the Fastest SQL Engine on Pandas DataFrame

“ClickHouse works very well as part of our multi-system data stack. It’s excellent for time-series data, and the VersionedCollapsingMergeTree engine was a game-changer for us, speeding up queries from 20 seconds in Snowflake to 1.5 seconds in ClickHouse.”

large_Chartmetric User Story Issue 1213.png

medium_Chartmetric User Story Issue 1213.png

small_Chartmetric User Story Issue 1213.png

thumbnail_Chartmetric User Story Issue 1213.png

Chartmetric User Story Issue 1213.png

Behind the music: How Chartmetric is scaling music analytics with ClickHouse

Announcing the Bindplane + ClickStack integration. Read how Bindplane helps ClickStack scale to petabyte observability by taking the pain out of running and scaling OpenTelemetry collectors.

large_clickhouse_bindplane.png

medium_clickhouse_bindplane.png

small_clickhouse_bindplane.png

thumbnail_clickhouse_bindplane.png

clickhouse_bindplane.png

Bindplane + ClickStack: Operating OpenTelemetry collectors at scale

Mike Shi, Head of Observability at ClickHouse, reflects on a pivotal year building ClickStack and learning from users. From cardinality and trace-first systems to OpenTelemetry and AI SRE, he shares what changed in 2025 and what matters next.

large_o11y-year-in-review.png

medium_o11y-year-in-review.png

small_o11y-year-in-review.png

thumbnail_o11y-year-in-review.png

o11y-year-in-review.png

Observability - a year in review

A look back at the later half of 2025 in the world of ClickStack.

large_image12.png

medium_image12.png

small_image12.png

thumbnail_image12.png

image12.png

ClickStack: A (half) year in review

Most AI SRE tools sound smart but fall apart in real incidents. Manveer Chawla explains why the problem isn’t the model, it’s the observability foundation, and how fixing that changes everything.

large_AI_SRE.png

medium_AI_SRE.png

small_AI_SRE.png

thumbnail_AI_SRE.png

AI_SRE.png

Your AI SRE needs better observability, not bigger models.

At ClickHouse, we don't like the word "impossible." We believe that with the right tools, everything is a data problem. To prove it, we decided to complete the 2025 Advent of Code unconventionally: using pure ClickHouse SQL.

large_Advent of code 2025 (2).png

medium_Advent of code 2025 (2).png

small_Advent of code 2025 (2).png

thumbnail_Advent of code 2025 (2).png

Advent of code 2025 (2).png

Solving the "Impossible" in ClickHouse: Advent of Code 2025

ClickStack’s December update introduces the intelligent use of Materialized Views that automatically accelerate charts and dashboards, delivering faster insights at scale with zero user effort.

large_Whats new in ClickStack December 2031.jpg

medium_Whats new in ClickStack December 2031.jpg

small_Whats new in ClickStack December 2031.jpg

thumbnail_Whats new in ClickStack December 2031.jpg

Whats new in ClickStack December 2031.jpg

What's new in ClickStack. December '25.

Have a look at some of the most notable demos we built this year, and how they help people feel the speed of ClickHouse through real, hands-on examples.

large_demos-review-banner.jpg

medium_demos-review-banner.jpg

small_demos-review-banner.jpg

thumbnail_demos-review-banner.jpg

demos-review-banner.jpg

A look back at 2025 demo development at ClickHouse

A collection of my favorite technology blogs

large_perf.png

medium_perf.png

small_perf.png

thumbnail_perf.png

perf.png

Good technology blogs: a reading list for the holidays

Over 100 functions were added to ClickHouse in 2025. These were some of my favorites.

large_ClickHouse New Functions 2025.jpg

medium_ClickHouse New Functions 2025.jpg

small_ClickHouse New Functions 2025.jpg

thumbnail_ClickHouse New Functions 2025.jpg

ClickHouse New Functions 2025.jpg

New functions you might have missed in 2025

We're excited to announce that ClickHouse Cloud is now available as a private region on Microsoft Azure UAE North (Dubai).

large_ClickHouse Cloud Azure UAE North.jpg

medium_ClickHouse Cloud Azure UAE North.jpg

small_ClickHouse Cloud Azure UAE North.jpg

thumbnail_ClickHouse Cloud Azure UAE North.jpg

ClickHouse Cloud Azure UAE North.jpg

ClickHouse Cloud now available on Azure UAE North: Bringing real-time analytics to the heart of the Middle East

Replicate data from MongoDB into ClickHouse Cloud in just a few clicks for blazing-fast analytics on document-based data. Now with more connectivity options, improved reliability, and support for DocumentDB.

Blog

MongoDB CDC connector for ClickPipes is now in Public Beta