ClickHouse

Consuming the Delta Lake Change Data Feed for CDC In this post, we share everything we have learnt from our investigation into working with Delta Lake’s Change Data Feed (CDF). On top, we’re open sourcing an MIT-licensed, reference implementation of…

How do you stream changes from Delta Lake into ClickHouse?

1️⃣ We share what we learned using Delta Lake CDF
2️⃣ We open sourced a Python reference CDC implementation
3️⃣ Performance, schema design, and caveats

Get ready for House Party: The SQL 🕺 🪩

The Chainsmokers are back for round two on Dec 2 in Vegas. This is where database engineers become dance floor legends!

Sign up to save the date and get notified the moment registration opens.

clickhouse.com/company/even...

An ORM for ClickHouse? Let's look at the open-source, MIT-licensed project Moose OLAP from fiveonefour. Inspired by the likes of SQLAlchemy, Drizzle and Prisma, it adapts the ORM experience to work on analytical databases like ClickHouse.

clickhou.se/3JkY30l

You can’t UPDATE what you can’t find: ClickHouse vs PostgreSQL See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.

Curiosity got the better of us: how do ClickHouse’s new UPDATEs compare to Postgres?
clickhou.se/3Hx2XXx
⚡ Single-row updates: parity
🚀 Bulk updates: up to 4,000× faster

HIPAA and PCI Compliance at ClickHouse HIPAA and PCI self-service deployments are now generally available in ClickHouse Cloud

HIPAA and PCI self-service deployments are now generally available in ClickHouse Cloud!

ClickHouse has a wonderful feature that is often forgotten - table cloning:
presentations.clickhouse.com/2024-release...
You can take any table and create an instant snapshot (aka branch) of it.
This feature has been available since 24.10.
Instant backups of large tables - one of the applications.

YouTube video by ClickHouse ClickHouse v25.7 Release Webinar

We are live with the ClickHouse 25.7 release webinar.

Join us for demos & Q/A

www.youtube.com/watch?v=P1Ts...

Agentic analytics in Slack with ClickHouse, MCP, and PydanticAI Let’s build a self-service analytics agent that we can talk to directly in Slack, that transparently queries our ClickHouse data warehouse.

Is Slack the new BI layer for the AI era?

It's now possible to build custom, self-service agentic analytics experiences in a single afternoon thanks to Slack, @pydantic.dev @anthropic.com MCP and ClickHouse

v25.7 Community Call Every month we get together with the community (users, contributors, customers, those interested in learning more about ClickHouse) to discuss what is coming in the latest release.

It's the ClickHouse 25.7 release.

What do you hope will be released this month?

Also, join us for the live demos & Q/A

clickhouse.com/company/even...

Kevin Egan joins ClickHouse as Chief Revenue Officer to accelerate growth ClickHouse, a leader in real-time analytics, data warehousing, observability, and AI/ML, today announced the appointment of Kevin Egan as Chief Revenue Officer (CRO). With over two decades of experien...

Welcome Kevin Egan as our CRO!

With a history of scaling giants like Atlassian, Slack & Salesforce, now he's joining us for the next big chapter! 🚀

clickhouse.com/blog/kevin-e...

Why OpenAI chose ClickHouse for petabyte-scale observability OpenAI ingests petabytes of logs a day, and ClickHouse is how they keep up. From billion-model experiments to viral ChatGPT spikes, see how they built observability for everything.

Every day, @OpenAI ingests petabytes of log data, the equivalent of 📚 500 Libraries of Congress or 📸 2 billion iPhone photos.

Here’s why they chose @ClickHouseDB for observability, and how it held up under pressure 🚀🔍:

YouTube video by ClickHouse v25.6 Community Call

We are live with the 25.6 ClickHouse release call.

Join us now for feature overviews, live demos, and Q&A

www.youtube.com/watch?v=_9IB...

v25.6 Community Call Every month we get together with the community (users, contributors, customers, those interested in learning more about ClickHouse) to discuss what is coming in the latest release.

It's the 25.6 release and community call.

Join us for feature overviews, live demos, and Q&A

clickhouse.com/company/even...

Join me if you can: ClickHouse vs. Databricks & Snowflake - Part 2 We took the same JOIN-heavy benchmark from Part 1 and made ClickHouse even faster. By replacing JOINs with in-memory dictionaries, we saw up to 6.6× faster queries and over 60% cost savings, with no…

ClickHouse was already ahead.
Now it’s tuned. With two espressos! Kidding, dictionaries.
🚀 Up to 6.6× faster queries
💸 60% lower cost
📊 See the full benchmark:

Join me if you can: ClickHouse vs. Databricks & Snowflake - Part 1 We took a public benchmark that tests join-heavy SQL queries on Databricks and Snowflake and ran the exact same queries on ClickHouse Cloud.

We ran the Databricks vs. Snowflake JOIN benchmark on ClickHouse Cloud, here’s what happened.

dub.sh/O2mGXmS

Scaling our Observability platform beyond 100 Petabytes by embracing wide events and replacing OTel Read how we scaled our observability platform from 19PB to 100PB and 500 trillion rows by replacing OpenTelemetry with a native ClickHouse-to-ClickHouse pipeline, embracing wide events and cutting…

Last year, we shared how we saved millions by moving off Datadog and onto ClickHouse.

dub.sh/N5xB22L

Since then, things have scaled… a lot.
🚀 From 19PB → 100PB of uncompressed logs
📈 40 trillion → 500 trillion rows
💥 20× more throughput, using 90% less CPU

ClickHouse Summer Meetup Amsterdam, Wed, Jun 25, 2025, 6:00 PM | Meetup ## Details Location: Picnic HQ Van Marwijk Kooystraat 15 · Amsterdam, NH Hey there, data enthusiasts and ClickHouse aficionados! We've got some exciting news to share - o

www.meetup.com/clickhouse-n...

v25.6 Community Call Every month we get together with the community (users, contributors, customers, those interested in learning more about ClickHouse) to discuss what is coming in the latest release.

It’s time for the ClickHouse 25.6 release call with Alexey Milovidov 🔥

This release features:
- ClickHouse’s native time datatype to keep you on schedule
- JSON reader for Parquet files

Catch the full update on June 26th on Zoom and YouTube live.
clickhouse.com/company/even...

GitHub - ClickHouse/clickhouse-analyzer: SQL analyzer for ClickHouse SQL SQL analyzer for ClickHouse SQL. Contribute to ClickHouse/clickhouse-analyzer development by creating an account on GitHub.

Parsing ClickHouse SQL in Rust: github.com/ClickHouse/c...

YouTube video by ClickHouse How is the AI Made? The Data Behind Language Models

New video, only 11 minutes: www.youtube.com/watch?v=8yH3...

Open House 2025, The ClickHouse User Conference - Watch the Sessions.

Open House session recordings are live! 🍿Catch up on the latest ClickHouse releases, customer stories and user interviews at clickhouse.com/openhouse#vi....

Birds in the cloud ClickHouse handles 1.5B bird observations with ease. Alexey Milovidov shows how to go from raw data to interactive maps, with full pipeline and best practices.

New article about data engineering, now with birds:
clickhouse.com/blog/birds

ClickHouse Release 25.5 is published!

Presentation: presentations.clickhouse.com/2025-release...
Video: www.youtube.com/live/wxicecq...
Changelog: github.com/ClickHouse/C...

Maruth Goyal joins the Open House speaker lineup to share how Anthropic leverages ClickHouse to improve observability. 🔍

See you in San Francisco next week! clickhouse.com/openhouse

Live next week at Open House 🎙️ Hear how the OpenAI observability team scaled ClickHouse as ChatGPT adoption, and log volume, skyrocketed.

Register at clickhouse.com/openhouse

Parquet powers Iceberg and Delta Lake.
ClickHouse powers lightning-fast queries on Parquet.
This post takes you deep inside the query engine to show how it works, and why that makes ClickHouse a formidable Lakehouse engine.
buff.ly/ZUE8C73

Lyft is set to speak at Open House on May 29th 🙌 Hear first-hand how Lyft leverages ClickHouse for near real-time and sub-second analytics enabling swift decision-making.

Register to hear their talk at Open House: clickhouse.com/openhouse

With a whopping 150 TB of logs generated monthly, find out how Clever leverages ClickHouse to supercharge their observability. Join us tomorrow for a live Q&A with the Clever engineers behind the observability engine. Bring your questions!

Register at clickhouse.com/company/even...

How to automatically associate console logs by request with @opentelemetry.io and @hyperdx.bsky.social

docs.deno.com/examples/hyp...

YouTube video by ClickHouse ClickHouse v25.4 Release Webinar

We are live with the ClickHouse 25.4 Release Call!

Join us, now, to catch up on the most recent features. Enjoy some live demos. And bring your questions for Q&A time at the end.

www.youtube.com/watch?v=7wbf...