# ClickHouse Blog

Welcome to the ClickHouse Blog!

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## The day the sky emptied: rendering the FAA outage with ClickHouse FORMAT PNG

DevFeed: [The day the sky emptied: rendering the FAA outage with ClickHouse FORMAT PNG](<https://devfeed.tech/articles/the-day-the-sky-emptied-rendering-the-faa-outage-with-clickhouse-format-png-140979.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/faa-outage-clickhouse-format-png>)

Author: Alexey Milovidov

Published: 2026-11-18T09:26:18Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [web graphics](<https://devfeed.tech/topics/web-graphics.md>), [Image](<https://devfeed.tech/topics/image.md>), [data transformation](<https://devfeed.tech/topics/data-transformation.md>), [Structured-data](<https://devfeed.tech/topics/structured-data.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [cURL](<https://devfeed.tech/topics/curl.md>)

Tags: [ads-b](<https://devfeed.tech/tags/ads-b.md>), [air-traffic](<https://devfeed.tech/tags/air-traffic.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [faa](<https://devfeed.tech/tags/faa.md>), [faa-outage](<https://devfeed.tech/tags/faa-outage.md>), [rendering](<https://devfeed.tech/tags/rendering.md>), [sql](<https://devfeed.tech/tags/sql.md>), [us](<https://devfeed.tech/tags/us.md>)

### AI overview

The excerpt reports that ADS-B positions show US air traffic thinning sharply after about 15:40 ET during the described November 13, 2026 FAA outage: by 20:00 ET, aircraft at cruising altitude were below one tenth of early afternoon levels, while high-altitude traffic began returning after 21:00. It explains how ClickHouse renders the day as an animated PNG directly from SQL: server-side aggregation produces per-frame pixel data, then SQL layers aircraft colors, a faint all-day trace, timeline, and text into the image. Because the public endpoint caps results at about one million rows, aggregation runs in 24 hourly queries and is rendered locally. For a still comparison, a separate query renders two panels directly on the server; its read-only public user limits canvas size. The excerpt also notes tradeoffs: ordinary animation rendering holds about 1.2 GB of frames in memory, streaming uses one frame but requires time ordering and may produce files some decoders reject, and palette conversion reduces APNG size from 150 MB to 25 MB.

### Source excerpt

Visualize the November 13 FAA outage using ADS-B flight data and ClickHouse's FORMAT PNG, rendering an entire day of US air traffic directly from SQL.

## Why Front migrated from Elasticsearch to ClickHouse for "pixel-perfect" analytics at scale

DevFeed: [Why Front migrated from Elasticsearch to ClickHouse for "pixel-perfect" analytics at scale](<https://devfeed.tech/articles/why-front-migrated-from-elasticsearch-to-clickhouse-for-pixel-perfect-analytics-at-scale-144379.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/front-elasticsearch-clickhouse>)

Author: ClickHouse

Published: 2026-11-18T00:00:00Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [metric-standardization](<https://devfeed.tech/topics/metric-standardization.md>), [product analytics](<https://devfeed.tech/topics/product-analytics.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>)

Tags: [aggregation](<https://devfeed.tech/tags/aggregation.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [aws](<https://devfeed.tech/tags/aws.md>), [b2b](<https://devfeed.tech/tags/b2b.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [customer](<https://devfeed.tech/tags/customer.md>), [data](<https://devfeed.tech/tags/data.md>), [days](<https://devfeed.tech/tags/days.md>), [development](<https://devfeed.tech/tags/development.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [metric](<https://devfeed.tech/tags/metric.md>), [more](<https://devfeed.tech/tags/more.md>), [pixel](<https://devfeed.tech/tags/pixel.md>), [scale](<https://devfeed.tech/tags/scale.md>)

### AI overview

Front moved customer-facing analytics from Elasticsearch to ClickHouse Cloud as its 25 TB workload and specialized Painless queries made new metrics slow and dependent on senior analytics engineers. It migrated gradually, writing each new event to both systems and comparing metrics, then defined each metric once in a shared framework that generates visualizations. For mutable conversations, VersionedCollapsingMergeTree reconciles changes such as deleted messages and merged threads. In one large customer's tag report, a 30-second query grew from 11 days of history in Elasticsearch to a month and a half in ClickHouse, using half as many machines of equal performance. The first metric built in the new framework took a junior engineer three days, versus several weeks for a senior engineer with Elasticsearch. The account also reports cloud-region moves dropping from days to minutes. Front says the change enables more flexible dashboards and plans to explore backlog metrics and AI-assisted metric creation.

### Source excerpt

Front powers customer-facing analytics for 9,000+ B2B companies with ClickHouse Cloud, cutting metric development from three weeks to three days and querying 4x more historical data.

## Bring your Claude Platform organization to ClickHouse Cloud with linked billing

DevFeed: [Bring your Claude Platform organization to ClickHouse Cloud with linked billing](<https://devfeed.tech/articles/bring-your-claude-platform-organization-to-clickhouse-cloud-with-linked-billing-139653.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/claude-platform-linked-billing>)

Author: Ryadh Dahimene; Alice Dalby; Andrew Wilkins

Published: 2026-11-17T18:14:57Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Claude](<https://devfeed.tech/topics/claude.md>), [anthropic](<https://devfeed.tech/topics/anthropic.md>)

Tags: [admin](<https://devfeed.tech/tags/admin.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [anthropic](<https://devfeed.tech/tags/anthropic.md>), [api](<https://devfeed.tech/tags/api.md>), [api-key](<https://devfeed.tech/tags/api-key.md>), [beta](<https://devfeed.tech/tags/beta.md>), [billing](<https://devfeed.tech/tags/billing.md>), [claude](<https://devfeed.tech/tags/claude.md>), [claude-api](<https://devfeed.tech/tags/claude-api.md>), [claude-console](<https://devfeed.tech/tags/claude-console.md>), [claude-platform](<https://devfeed.tech/tags/claude-platform.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [functions](<https://devfeed.tech/tags/functions.md>), [link](<https://devfeed.tech/tags/link.md>), [organization](<https://devfeed.tech/tags/organization.md>), [platform](<https://devfeed.tech/tags/platform.md>), [terms](<https://devfeed.tech/tags/terms.md>)

### AI overview

Linked billing lets eligible ClickHouse Cloud customers charge Claude API use in ClickHouse Agents and AI Functions directly to their existing Claude organization, without sharing or managing an API key. An admin authorizes the link, sets an optional monthly spend limit, and can review or unlink it in either console. Anthropic bills the usage on the Claude organization's existing terms, while requests run in the ClickHouse organization and follow its settings; Claude-side controls such as ZDR, IP allowlists, and encryption keys do not carry over. ClickHouse Cloud serves Claude models only while linked billing is enabled. Customers must ask their ClickHouse account team to enable it and have the required admin or owner/billing roles.

### Source excerpt

Link your Claude Platform organization to ClickHouse Cloud and have Anthropic bill Claude API usage in ClickHouse Agents and AI Functions directly on your existing terms.

## Trunk cuts observability costs by up to 95% and reclaims 20 engineering hours a week with ClickHouse Observability

DevFeed: [Trunk cuts observability costs by up to 95% and reclaims 20 engineering hours a week with ClickHouse Observability](<https://devfeed.tech/articles/trunk-cuts-observability-costs-by-up-to-95-and-reclaims-20-engineering-hours-a-week-with-clickhouse-observability-140980.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/trunk-clickstack-observability>)

Author: ClickHouse

Published: 2026-11-17T00:00:00Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-assisted](<https://devfeed.tech/tags/ai-assisted.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [aws](<https://devfeed.tech/tags/aws.md>), [ci](<https://devfeed.tech/tags/ci.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [costs](<https://devfeed.tech/tags/costs.md>), [detection](<https://devfeed.tech/tags/detection.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [flaky](<https://devfeed.tech/tags/flaky.md>), [observability](<https://devfeed.tech/tags/observability.md>), [test](<https://devfeed.tech/tags/test.md>)

### AI overview

Trunk reports that ClickHouse Observability costs 15-20 times less to run than Datadog while handling all its traffic without log sampling; it retains 30 days of info-level-and-higher logs. Using ClickStack's OpenTelemetry collector and UI, the team brings logs, traces, and metrics together for human and agent investigations. Trunk says AI-assisted triage with ClickStack MCP and Claude Code or Codex returns about 20 engineering hours a week, and it found separate AI SRE tools unnecessary. Separately, migrating CI analytics from self-managed TimescaleDB to ClickHouse Cloud on AWS reduced flaky-test detection from up to an hour to five minutes or less and eased maintenance. The migration proceeded through ClickPipes syncing, dual writes, then ClickHouse-only writes; some Postgres tables still replicate. Private connectivity in Trunk's region was needed to avoid egress costs. The article is a company case study reporting Trunk's estimates and experience.

### Source excerpt

Trunk cuts observability costs by up to 95%, reclaims 20 engineering hours a week, and accelerates flaky test detection with ClickHouse.

## More load is faster: Tuning Postgres read replicas

DevFeed: [More load is faster: Tuning Postgres read replicas](<https://devfeed.tech/articles/more-load-is-faster-tuning-postgres-read-replicas-140981.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/tuning-postgres-read-replicas>)

Author: Colton Shepard

Published: 2026-11-17T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [read-replica](<https://devfeed.tech/topics/read-replica.md>), [consistency](<https://devfeed.tech/topics/consistency.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [lag](<https://devfeed.tech/tags/lag.md>), [latency](<https://devfeed.tech/tags/latency.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [read-replicas](<https://devfeed.tech/tags/read-replicas.md>), [settings](<https://devfeed.tech/tags/settings.md>), [testing](<https://devfeed.tech/tags/testing.md>), [tradeoffs](<https://devfeed.tech/tags/tradeoffs.md>), [traffic](<https://devfeed.tech/tags/traffic.md>), [wal](<https://devfeed.tech/tags/wal.md>), [write](<https://devfeed.tech/tags/write.md>)

### AI overview

The tests found that ordinary traffic can keep Postgres read replica lag to a few seconds, while very low write volume can leave replicas waiting for WAL segments to switch--up to the default 60-second archive timeout. In the tested archive-based setup, `archive_timeout=5s` and `wal_retrieve_retry_interval=500ms` are offered as a relatively safe starting point; polling faster gave diminishing returns because WAL-G fetches took about 0.8 seconds. Shorter timeouts increase object-storage re-fetching, replica CPU use, and network costs with synchronous HA. Forcing WAL switches reduced primary throughput by about 15% and added more overhead. Streaming replication was faster, but the article cites vacuum, disk, primary-load, and failover risks as reasons not to make it the default for read replicas.

### Source excerpt

Testing Postgres read replicas reveals why more write traffic can reduce lag, how WAL settings affect latency, and where aggressive tuning introduces tradeoffs.

## How Infinitas Learning uses ClickHouse Managed Postgres to process billions of events for 1.6M unique learners

DevFeed: [How Infinitas Learning uses ClickHouse Managed Postgres to process billions of events for 1.6M unique learners](<https://devfeed.tech/articles/how-infinitas-learning-uses-clickhouse-managed-postgres-to-process-billions-of-events-for-1-6m-unique-learners-136653.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/infinitas-learning-clickhouse-managed-postgres>)

Author: ClickHouse

Published: 2026-11-16T10:54:45Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Apache Kafka](<https://devfeed.tech/topics/apache-kafka.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>)

Tags: [1-6](<https://devfeed.tech/tags/1-6.md>), [about](<https://devfeed.tech/tags/about.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [distributed](<https://devfeed.tech/tags/distributed.md>), [distributed-cache](<https://devfeed.tech/tags/distributed-cache.md>), [events](<https://devfeed.tech/tags/events.md>), [latency](<https://devfeed.tech/tags/latency.md>), [learning](<https://devfeed.tech/tags/learning.md>), [managed](<https://devfeed.tech/tags/managed.md>), [p99](<https://devfeed.tech/tags/p99.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [process](<https://devfeed.tech/tags/process.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [time](<https://devfeed.tech/tags/time.md>), [transactions](<https://devfeed.tech/tags/transactions.md>), [unique](<https://devfeed.tech/tags/unique.md>), [uses](<https://devfeed.tech/tags/uses.md>)

### AI overview

Infinitas Learning separates learner-result transactions from customer-facing analytics: Postgres processes assignment events and updates learner progress, while ClickHouse Cloud serves teacher dashboards. After Neon, the team moved 750 GB to ClickHouse Managed Postgres in 16 hours and completed a no-downtime cutover in 20 minutes; reported P50 transaction latency fell from milliseconds to double-digit microseconds. For analytics, ClickHouse compressed a nearly 2-billion-row table from 300 GB to 27 GB, but cache misses caused P99 spikes up to 13 seconds against a 500 ms target. Self-hosting brought P99 to 300 ms but left the team responsible for operations and running a single replica. With ClickHouse support optimizing data and settings, then enabling distributed cache in Cloud, load-test P99 reached 410 ms. The team plans to connect Postgres and ClickHouse through pg_clickhouse, but that integration is described as a future vision.

### Source excerpt

Infinitas Learning runs transactions for 1.6 million learners on ClickHouse Managed Postgres and serves real-time analytics to teachers from ClickHouse Cloud, where distributed cache cut P99 latency from about 13 seconds to 410 milliseconds.

## JSONBench is back, and ClickHouse still leads

DevFeed: [JSONBench is back, and ClickHouse still leads](<https://devfeed.tech/articles/jsonbench-is-back-and-clickhouse-still-leads-136654.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/jsonbench-is-back-clickhouse-still-leads>)

Author: Tom Schreiber; Mark Needham

Published: 2026-11-16T00:30:00Z

Content type: news

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [JSON](<https://devfeed.tech/topics/json.md>), [DuckDB](<https://devfeed.tech/topics/duckdb.md>), [reproducibility](<https://devfeed.tech/topics/reproducibility.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [Compression](<https://devfeed.tech/topics/compression.md>)

Tags: [benchmark](<https://devfeed.tech/tags/benchmark.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [database](<https://devfeed.tech/tags/database.md>), [engines](<https://devfeed.tech/tags/engines.md>), [json](<https://devfeed.tech/tags/json.md>)

### AI overview

In the described billion-document Bluesky event aggregation, ClickHouse returned results in 661 ms on a cold run, while MongoDB took 32 minutes 26 seconds on the same machine type and published configurations. The article attributes ClickHouse's JSON analytics performance to columnar storage, compression, and parallel processing that reads the fields a query needs. JSONBench has expanded from five to 27 database engines; ClickHouse also leads the broader comparison, which reports combined scores rather than query-time multipliers and penalizes unsuccessful queries and incomplete loads. The benchmark is open source, with public data, queries, configurations, and results, so others can reproduce measurements or contribute systems and improvements. The article also cites ClickHouse JSON changes including faster reads, lower memory use, indexes, Parquet support, and type hints without rewriting historical data.

### Source excerpt

JSONBench now compares 27 database engines. ClickHouse still leads on a billion JSON documents. Explore the results and run the benchmark yourself.

## Introducing Loom: agent memory that keeps up with your code

DevFeed: [Introducing Loom: agent memory that keeps up with your code](<https://devfeed.tech/articles/introducing-loom-agent-memory-that-keeps-up-with-your-code-133720.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/introducing-loom-agent-memory-that-keeps-up-with-your-code>)

Author: James Cunningham; Lareb Zafar

Published: 2026-11-13T13:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [AI Context Management](<https://devfeed.tech/topics/ai-context-management.md>), [Retrieval Augmented Generation (RAG)](<https://devfeed.tech/topics/retrieval-augmented-generation-rag.md>), [Multi Agent Systems](<https://devfeed.tech/topics/multi-agent-systems.md>), [Claude Code](<https://devfeed.tech/topics/claude-code.md>), [codex](<https://devfeed.tech/topics/codex.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [Pull Request](<https://devfeed.tech/topics/pull-request.md>), [Code review](<https://devfeed.tech/topics/code-review.md>), [Continuous integration](<https://devfeed.tech/topics/continuous-integration.md>)

Tags: [access-control](<https://devfeed.tech/tags/access-control.md>), [agent-memory](<https://devfeed.tech/tags/agent-memory.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [apache](<https://devfeed.tech/tags/apache.md>), [apache-2-0](<https://devfeed.tech/tags/apache-2-0.md>), [api](<https://devfeed.tech/tags/api.md>), [audit](<https://devfeed.tech/tags/audit.md>), [audit-trail](<https://devfeed.tech/tags/audit-trail.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [bm25](<https://devfeed.tech/tags/bm25.md>), [bm25-search](<https://devfeed.tech/tags/bm25-search.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [code](<https://devfeed.tech/tags/code.md>), [coding-agents](<https://devfeed.tech/tags/coding-agents.md>), [grounded](<https://devfeed.tech/tags/grounded.md>), [index](<https://devfeed.tech/tags/index.md>), [loom](<https://devfeed.tech/tags/loom.md>), [memory](<https://devfeed.tech/tags/memory.md>), [repository](<https://devfeed.tech/tags/repository.md>)

### AI overview

Loom combines shared agent memory and a repository code index in one ClickHouse database, linking notes to code so changes can flag memories for review. It indexes functions, classes, and call relationships; searches memory using vector, BM25, text-chunk, and entity-graph queries scoped to caller permissions; and retains fact versions and provenance. Teams can configure one-way, shared read/write, or personal-to-shared memory flows. On the authors' benchmarks, code-answer scores rose from 0.78 to 0.84 and file-finding accuracy from 91.4% to 96.4%, with lower average costs; a 100-question memory comparison found 94% accuracy versus 90% using full conversation history and about 90% fewer tokens, though that gap was not statistically significant. Loom requires ClickHouse 26.5 or later (26.8 recommended for faster vector search). Its index reflects the server's branch mirror, so uncommitted changes are not included until committed and pushed.

### Source excerpt

Loom gives coding agents shared memory and a code index grounded in the repository, so each session can build on what the last one learned.

## SET allow\_preview\_features = 1: Self-service previews in ClickHouse Cloud

DevFeed: [SET allow\_preview\_features = 1: Self-service previews in ClickHouse Cloud](<https://devfeed.tech/articles/set-allow-preview-features-1-self-service-previews-in-clickhouse-cloud-131559.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/self-service-previews-in-clickhouse-cloud>)

Author: Amy Chen

Published: 2026-11-13T09:32:01Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [self-service](<https://devfeed.tech/topics/self-service.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [OpenAPI Specification](<https://devfeed.tech/topics/openapi.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-assisted](<https://devfeed.tech/tags/ai-assisted.md>), [api](<https://devfeed.tech/tags/api.md>), [audit-log](<https://devfeed.tech/tags/audit-log.md>), [automation](<https://devfeed.tech/tags/automation.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [compute](<https://devfeed.tech/tags/compute.md>), [console](<https://devfeed.tech/tags/console.md>), [cost](<https://devfeed.tech/tags/cost.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data-lake](<https://devfeed.tech/tags/data-lake.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [development](<https://devfeed.tech/tags/development.md>), [discovery](<https://devfeed.tech/tags/discovery.md>), [docs](<https://devfeed.tech/tags/docs.md>), [features](<https://devfeed.tech/tags/features.md>), [feedback](<https://devfeed.tech/tags/feedback.md>), [preview](<https://devfeed.tech/tags/preview.md>), [self-service](<https://devfeed.tech/tags/self-service.md>)

### AI overview

ClickHouse Cloud's Previews page lets eligible organizations discover preview features, enable some themselves, or request access to others. Previews are experimental and excluded from default SLAs; use caution, especially in production. Only Org Admins can toggle organization-wide previews, changes appear in the audit log, and availability depends on plan or region. The initial self-enable options include monitoring features and Approved Domains (unavailable with SAML SSO or SCIM); On-Demand Compute and Schema Advisor require waitlist signup. Controls are also available through the Cloud OpenAPI, and previews provide feedback buttons. Features leave the page when they graduate to the next product stage.

### Source excerpt

ClickHouse Cloud now has a Previews page where anyone can discover preview features, enable some themselves, join waitlists for others, and send feedback, with API support for automation.

## Bring high-performance analytics to your lakehouse with ClickHouse and Amazon S3 Tables

DevFeed: [Bring high-performance analytics to your lakehouse with ClickHouse and Amazon S3 Tables](<https://devfeed.tech/articles/bring-high-performance-analytics-to-your-lakehouse-with-clickhouse-and-amazon-s3-tables-131558.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-amazon-s3-tables>)

Author: AWS

Published: 2026-11-11T00:00:00Z

Content type: tutorial

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Amazon S3 Tables](<https://devfeed.tech/topics/amazon-s3-tables.md>), [Apache Iceberg](<https://devfeed.tech/topics/apache-iceberg.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>)

Tags: [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [amazon-athena](<https://devfeed.tech/tags/amazon-athena.md>), [amazon-bedrock](<https://devfeed.tech/tags/amazon-bedrock.md>), [amazon-emr](<https://devfeed.tech/tags/amazon-emr.md>), [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [amazon-s3-tables](<https://devfeed.tech/tags/amazon-s3-tables.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [apache-iceberg](<https://devfeed.tech/tags/apache-iceberg.md>), [aws-glue](<https://devfeed.tech/tags/aws-glue.md>), [aws-identity-and-access-management-iam](<https://devfeed.tech/tags/aws-identity-and-access-management-iam.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [iceberg](<https://devfeed.tech/tags/iceberg.md>), [retail-analytics](<https://devfeed.tech/tags/retail-analytics.md>)

### AI overview

ClickHouse can query Apache Iceberg data in Amazon S3 Tables through the Iceberg REST endpoint, transform it with SQL, and write curated results back without migrating the source data. The walkthrough uses ClickHouse's DataLakeCatalog engine and AWS IAM credentials to join retail purchases and returns into a reusable daily performance table; other Iceberg-compatible engines can then read that table. S3 Tables manage storage, metadata, and automatic maintenance, while ClickHouse performs analytics. The article also describes using ClickHouse as a tool for iterative AI agent queries and writes. The workflow requires self-managed ClickHouse 26.8 or later; this read/write path is not yet generally available in ClickHouse Cloud. Querying in place has different latency and throughput from local MergeTree tables: the article suggests it for exploration, batch transforms, and low-concurrency workloads, and materialization for consistently low-latency, high-concurrency dashboards or applications. For centralized catalog governance, fine-grained access across engines, or cross-account access, it points to the AWS Glue Iceberg REST endpoint.

### Source excerpt

Connect ClickHouse to Amazon S3 Tables to query Iceberg data in place, transform retail analytics, and write reusable results back for dashboards and AI agents.

## ClickHouse Unifies Enterprise AI Data Stack with Launch of Expanded Platform

DevFeed: [ClickHouse Unifies Enterprise AI Data Stack with Launch of Expanded Platform](<https://devfeed.tech/articles/clickhouse-unifies-enterprise-ai-data-stack-with-launch-of-expanded-platform-124826.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-unifies-enterprise-ai-data-stack>)

Author: ClickHouse

Published: 2026-11-09T17:01:12Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [AI Infrastructure](<https://devfeed.tech/topics/ai-infrastructure.md>), [observability](<https://devfeed.tech/topics/observability.md>), [enterprise data protection](<https://devfeed.tech/topics/enterprise-data-protection.md>)

Tags: [acquisition](<https://devfeed.tech/tags/acquisition.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-costs](<https://devfeed.tech/tags/ai-costs.md>), [ai-development](<https://devfeed.tech/tags/ai-development.md>), [ai-engineering](<https://devfeed.tech/tags/ai-engineering.md>), [ai-gateway](<https://devfeed.tech/tags/ai-gateway.md>), [capabilities](<https://devfeed.tech/tags/capabilities.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [data-stack](<https://devfeed.tech/tags/data-stack.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [enterprise-ai](<https://devfeed.tech/tags/enterprise-ai.md>), [launch](<https://devfeed.tech/tags/launch.md>), [observability](<https://devfeed.tech/tags/observability.md>), [platform](<https://devfeed.tech/tags/platform.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

ClickHouse is expanding its platform across transactional databases, observability, security, and AI engineering, aiming to let enterprises run these workloads on one composable foundation. Managed Postgres is generally available in ClickHouse Cloud; Observability and Langfuse's open-source AI Gateway are in public beta, while Security is in private preview by request. ClickHouse says its Xata acquisition will add instant Postgres branching, cloning, scale-to-zero environments, and a dedicated AI-agent tier; these additions are planned. The excerpt also reports Mercado Libre processes 400 million spans per minute on ClickHouse, with 75x faster queries and roughly 89% compression, attributed to lower infrastructure costs.

### Source excerpt

Now serving more than 5,000 customers, ClickHouse is introducing new capabilities spanning Postgres, observability and security, alongside its acquisition of Xata, challenging established vendors across the enterprise.

## The observability UI as we know it is dead. So what comes next?

DevFeed: [The observability UI as we know it is dead. So what comes next?](<https://devfeed.tech/articles/the-observability-ui-as-we-know-it-is-dead-so-what-comes-next-124830.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/observability-ui-is-dead-whats-next>)

Author: Alex Fedotyev

Published: 2026-11-09T17:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [AI for interactive applications](<https://devfeed.tech/topics/ai-for-interactive-applications.md>), [User interface design](<https://devfeed.tech/topics/ui-design.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [tracing](<https://devfeed.tech/topics/tracing.md>)

Tags: [about](<https://devfeed.tech/tags/about.md>), [accessible](<https://devfeed.tech/tags/accessible.md>), [actions](<https://devfeed.tech/tags/actions.md>), [adversarial](<https://devfeed.tech/tags/adversarial.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [apps](<https://devfeed.tech/tags/apps.md>), [can](<https://devfeed.tech/tags/can.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [custom](<https://devfeed.tech/tags/custom.md>), [explore](<https://devfeed.tech/tags/explore.md>), [investigation](<https://devfeed.tech/tags/investigation.md>), [need](<https://devfeed.tech/tags/need.md>), [observability](<https://devfeed.tech/tags/observability.md>), [possible](<https://devfeed.tech/tags/possible.md>), [prompt](<https://devfeed.tech/tags/prompt.md>), [questions](<https://devfeed.tech/tags/questions.md>), [right](<https://devfeed.tech/tags/right.md>), [sql](<https://devfeed.tech/tags/sql.md>), [ui](<https://devfeed.tech/tags/ui.md>)

### AI overview

ClickHouse Observability Apps lets teams describe an observability workflow in natural language and have an agent build an interactive app over live data, with connected views, visualizations, and reusable investigation tools. SQL enables analyses beyond fixed endpoints, including joins and business-specific logic; queries can be inspected and are tested before use. Apps reuse ClickStack APIs and UI components, while OpenTelemetry conventions and team schema context help the agent interpret telemetry. Generated apps run in a sandboxed iframe and can request only validated actions; queries are read-only and use the viewing user's database permissions, so sharing an app does not share its creator's access. The product is in private preview. The authors say a successful query may still answer the wrong question, and they are improving evaluations, interaction testing, linting, and adversarial review. They also say prompt-injection robustness is not yet solved.

### Source excerpt

Your observability UI shouldn't limit the questions you can ask. Explore how ClickHouse Observability Apps turns a prompt into custom investigation experiences, why SQL makes it possible, and what we still need to get right.

## Announcing ClickHouse Observability - fully managed observability on ClickHouse Cloud

DevFeed: [Announcing ClickHouse Observability - fully managed observability on ClickHouse Cloud](<https://devfeed.tech/articles/announcing-clickhouse-observability-fully-managed-observability-on-clickhouse-cloud-124824.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/announcing-clickhouse-observability>)

Author: Mike Shi

Published: 2026-11-09T17:00:00Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [api](<https://devfeed.tech/tags/api.md>), [application](<https://devfeed.tech/tags/application.md>), [applications](<https://devfeed.tech/tags/applications.md>), [apps](<https://devfeed.tech/tags/apps.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [beta](<https://devfeed.tech/tags/beta.md>), [business](<https://devfeed.tech/tags/business.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [experience](<https://devfeed.tech/tags/experience.md>), [managed](<https://devfeed.tech/tags/managed.md>), [observability](<https://devfeed.tech/tags/observability.md>), [scale](<https://devfeed.tech/tags/scale.md>), [send](<https://devfeed.tech/tags/send.md>), [simple](<https://devfeed.tech/tags/simple.md>), [telemetry](<https://devfeed.tech/tags/telemetry.md>)

### AI overview

ClickHouse Observability is in public beta as a managed service on ClickHouse Cloud: teams send OpenTelemetry data to a managed OTLP endpoint, while ClickHouse manages ingestion, schemas, storage, and capacity. Logs and traces are billed by uncompressed gigabytes ingested ($0.20/GB); metrics by data points ($0.10/M), with 50% off during beta and 30 days of retention. ClickStack UI supports log, metric, and trace investigations; agents can use its MCP tools and SQL. Observability Apps, in private preview, lets users generate and refine custom interfaces from prompts. Generated code runs in a sandbox, and queries are read-only under the viewer's database permissions. Managed ClickStack remains available as a self-configured option, and ClickStack remains open source. The excerpt says beta work includes improving automatic scaling and schema optimization.

### Source excerpt

Introducing ClickHouse Observability: fully managed observability with the speed and scale of ClickHouse. Just send telemetry; we'll handle the rest. Plus, build the observability experience you've always wanted with a simple prompt in Observability Apps.

## Introducing ClickHouse Security in private preview, built on RunReveal

DevFeed: [Introducing ClickHouse Security in private preview, built on RunReveal](<https://devfeed.tech/articles/introducing-clickhouse-security-in-private-preview-built-on-runreveal-124827.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/introducing-clickhouse-security-agentic-siem>)

Author: Evan Johnson

Published: 2026-11-09T16:59:45Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Agentic SOC](<https://devfeed.tech/topics/agentic-soc.md>), [Security Information and Event Management (SIEM)](<https://devfeed.tech/topics/siem-security.md>), [alert triage](<https://devfeed.tech/topics/alert-triage.md>), [AI Chat](<https://devfeed.tech/topics/ai-chat.md>), [Security](<https://devfeed.tech/topics/security.md>), [observability](<https://devfeed.tech/topics/observability.md>)

Tags: [account](<https://devfeed.tech/tags/account.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agentic-workflows](<https://devfeed.tech/tags/agentic-workflows.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-chat](<https://devfeed.tech/tags/ai-chat.md>), [ai-development](<https://devfeed.tech/tags/ai-development.md>), [built-in](<https://devfeed.tech/tags/built-in.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [integrations](<https://devfeed.tech/tags/integrations.md>), [preview](<https://devfeed.tech/tags/preview.md>), [private](<https://devfeed.tech/tags/private.md>), [running](<https://devfeed.tech/tags/running.md>), [security](<https://devfeed.tech/tags/security.md>), [service](<https://devfeed.tech/tags/service.md>), [siem](<https://devfeed.tech/tags/siem.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

ClickHouse Security is entering private preview as an agentic SIEM that runs on a customer's own ClickHouse Cloud service. After approval, users sign in with their ClickHouse Cloud account, select a service, and provision schemas and views; they can then connect data sources, run agents, and detect threats. The platform offers more than 100 normalized integrations, built-in pipelines and managed detections, plus scheduled SQL or streaming Sigma rules. Agents support triage, detection work, and threat hunting, with natural-language chat and custom workflows through MCP, API, CLI, or Slack. During preview, the product is free, while customers pay standard ClickHouse Cloud compute and storage charges and must accept the Cloud Preview Addendum; general-availability pricing is not set. RunReveal continues with the same team and technology, but its multi-tenant ClickHouse cluster will no longer be an option; customers are expected to transition to their own ClickHouse services.

### Source excerpt

ClickHouse Security, an agentic SIEM built on RunReveal and ClickHouse Cloud, is now in private preview, with AI agents, 100+ integrations and built-in detections running on your own ClickHouse service.

## Langfuse launches AI Gateway

DevFeed: [Langfuse launches AI Gateway](<https://devfeed.tech/articles/langfuse-launches-ai-gateway-124828.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/langfuse-ai-gateway>)

Author: Marc Klingen; Tobias Wochinger; Hassieb Pakzad; Leonard Wolters

Published: 2026-11-09T16:57:37Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [LLM observability](<https://devfeed.tech/topics/llm-observability.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>), [litellm](<https://devfeed.tech/topics/litellm.md>)

Tags: [agent](<https://devfeed.tech/tags/agent.md>), [agent-harness](<https://devfeed.tech/tags/agent-harness.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-adoption](<https://devfeed.tech/tags/ai-adoption.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-applications](<https://devfeed.tech/tags/ai-applications.md>), [ai-assistants](<https://devfeed.tech/tags/ai-assistants.md>), [ai-costs](<https://devfeed.tech/tags/ai-costs.md>), [ai-engineering](<https://devfeed.tech/tags/ai-engineering.md>), [ai-gateway](<https://devfeed.tech/tags/ai-gateway.md>), [ai-observability](<https://devfeed.tech/tags/ai-observability.md>), [ai-requests](<https://devfeed.tech/tags/ai-requests.md>), [ai-usage](<https://devfeed.tech/tags/ai-usage.md>), [air-gapped](<https://devfeed.tech/tags/air-gapped.md>), [cost](<https://devfeed.tech/tags/cost.md>), [langfuse](<https://devfeed.tech/tags/langfuse.md>), [launches](<https://devfeed.tech/tags/launches.md>), [model](<https://devfeed.tech/tags/model.md>), [open-source](<https://devfeed.tech/tags/open-source.md>)

### AI overview

Langfuse launched its AI Gateway in public beta as a central entry point for company model traffic, including calls from coding agents. It supports spend dashboards, key-based spend limits and alerts, model approval, and optional Langfuse traces that can be searched, evaluated, and annotated. By default it records metadata, usage, and cost rather than prompt content; users can opt into full logging or use pass-through mode, and self-hosting keeps data on their infrastructure. The gateway is MIT-licensed, available on Langfuse Cloud or as a self-hosted 22 MB Docker image, and is built in Rust. The article reports under 3 ms median latency with tracing on and over 1,000 concurrent streams on a 2-vCPU node. Setup involves creating an organization gateway key and pointing an app to a regional gateway URL. Beta providers are OpenAI and Anthropic; OpenRouter, AWS, GCP, Azure, and custom APIs are described as forthcoming. Cloud charges currently apply only when requests are logged.

### Source excerpt

One open source entry point for all AI usage in your company. See every model call, who made it and what it cost, natively traced in Langfuse.

## ClickHouse Managed Postgres goes GA and Xata acquisition brings agentic capabilities to the service

DevFeed: [ClickHouse Managed Postgres goes GA and Xata acquisition brings agentic capabilities to the service](<https://devfeed.tech/articles/clickhouse-managed-postgres-goes-ga-and-xata-acquisition-brings-agentic-capabilities-to-the-service-124829.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/managed-postgres-ga-xata-acquisition>)

Author: Sai Srirampur

Published: 2026-11-09T16:56:11Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Tinybird news](<https://devfeed.tech/topics/tinybird-news.md>), [Heroku Postgres](<https://devfeed.tech/topics/heroku-postgres.md>), [Heroku AI](<https://devfeed.tech/topics/heroku-ai.md>), [internal developer platform automation](<https://devfeed.tech/topics/internal-developer-platform-automation.md>), [OpenAPI Specification](<https://devfeed.tech/topics/openapi.md>)

Tags: [acquisition](<https://devfeed.tech/tags/acquisition.md>), [agent-memory](<https://devfeed.tech/tags/agent-memory.md>), [agent-sandboxing](<https://devfeed.tech/tags/agent-sandboxing.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [ai-coding-agents](<https://devfeed.tech/tags/ai-coding-agents.md>), [ai-native](<https://devfeed.tech/tags/ai-native.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [automatic](<https://devfeed.tech/tags/automatic.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [developers](<https://devfeed.tech/tags/developers.md>), [developers-and-ai](<https://devfeed.tech/tags/developers-and-ai.md>), [instant](<https://devfeed.tech/tags/instant.md>), [managed](<https://devfeed.tech/tags/managed.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [scale](<https://devfeed.tech/tags/scale.md>), [zero](<https://devfeed.tech/tags/zero.md>)

### AI overview

ClickHouse Managed Postgres is generally available on AWS, combining local NVMe storage with native ClickHouse analytics connectivity. The excerpt reports 2-10x OLTP performance improvements, WAL-based sub-second replication through WalShadow, and ClickPipes as an included alternative; it also lists high availability, backups, pooling, replicas, observability, and enterprise security features. GCP remains in private preview. GA ends the beta discount and makes backup storage and public network egress billable, while ClickHouse connectivity and ClickPipes replication remain included. The Xata acquisition is intended to add copy-on-write instant branching and cloning, automatic idling, and scale-to-zero for isolated development and AI-agent environments. Existing Xata capabilities are available through customer onboarding; integration into ClickHouse Managed Postgres and a dedicated agent tier are planned, not yet described as launched.

### Source excerpt

ClickHouse Managed Postgres, our NVMe-backed Postgres service natively connected to ClickHouse, is generally available, and we're acquiring Xata to add instant branching, cloning and scale-to-zero for developers and AI agents.

## The largest expansion of ClickHouse yet

DevFeed: [The largest expansion of ClickHouse yet](<https://devfeed.tech/articles/the-largest-expansion-of-clickhouse-yet-124825.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/announcing-clickhouse-platform-largest-expansion>)

Author: ClickHouse

Published: 2026-11-09T00:45:00Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [LLM observability](<https://devfeed.tech/topics/llm-observability.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [Threat monitoring](<https://devfeed.tech/topics/threat-monitoring.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-gateway](<https://devfeed.tech/tags/ai-gateway.md>), [beta](<https://devfeed.tech/tags/beta.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [gateway](<https://devfeed.tech/tags/gateway.md>), [langfuse](<https://devfeed.tech/tags/langfuse.md>), [launches](<https://devfeed.tech/tags/launches.md>), [managed](<https://devfeed.tech/tags/managed.md>), [observability](<https://devfeed.tech/tags/observability.md>), [open](<https://devfeed.tech/tags/open.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [open-source-ai](<https://devfeed.tech/tags/open-source-ai.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [preview](<https://devfeed.tech/tags/preview.md>), [private](<https://devfeed.tech/tags/private.md>), [public](<https://devfeed.tech/tags/public.md>), [public-beta](<https://devfeed.tech/tags/public-beta.md>), [security](<https://devfeed.tech/tags/security.md>)

### AI overview

ClickHouse is expanding its cloud platform across transactions, observability, security, and AI engineering. Managed Postgres is generally available: NVMe-backed PostgreSQL includes high availability, automated backups, sub-second change data capture into ClickHouse, and the pg_clickhouse extension for querying ClickHouse through PostgreSQL. Xata's acquisition is intended to accelerate instant branching, cloning, and scale-to-zero environments. ClickHouse Observability is in public beta for OpenTelemetry logs, metrics, traces, and session data, with full-fidelity, high-cardinality retention and investigation at scale. ClickHouse Security is in private preview; its SIEM connects over 100 cloud, identity, and SaaS sources, provides built-in log pipelines and detections, and uses AI agents for alert triage and investigation. Langfuse's open-source AI Gateway is in public beta and routes model requests to trace usage and costs without application code changes; it is available self-hosted or on Langfuse Cloud.

### Source excerpt

ClickHouse Managed Postgres is generally available, ClickHouse Observability enters public beta, ClickHouse Security launches in private preview, Langfuse introduces an open-source AI Gateway, and ClickHouse acquires Xata.

## What I learned from a month with WalShadow on ClickHouse Managed Postgres

DevFeed: [What I learned from a month with WalShadow on ClickHouse Managed Postgres](<https://devfeed.tech/articles/what-i-learned-from-a-month-with-walshadow-on-clickhouse-managed-postgres-121767.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/a-month-with-walshadow-clickhouse-managed-postgres>)

Author: Hidehiko ASAHI

Published: 2026-11-06T16:16:22Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [database-consistency](<https://devfeed.tech/topics/database-consistency.md>), [Rockset](<https://devfeed.tech/topics/rockset.md>), [self-hosted databases vs managed services](<https://devfeed.tech/topics/self-hosted-databases-vs-managed-services.md>)

Tags: [aggregates](<https://devfeed.tech/tags/aggregates.md>), [cdc](<https://devfeed.tech/tags/cdc.md>), [changes](<https://devfeed.tech/tags/changes.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [latency](<https://devfeed.tech/tags/latency.md>), [managed](<https://devfeed.tech/tags/managed.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [preview](<https://devfeed.tech/tags/preview.md>), [private](<https://devfeed.tech/tags/private.md>), [replication](<https://devfeed.tech/tags/replication.md>), [schema](<https://devfeed.tech/tags/schema.md>), [testing](<https://devfeed.tech/tags/testing.md>)

### AI overview

In this September-October 2026 private-preview test, WalShadow's median replication latency stayed around 0.4 seconds from 1,000 to 200,000 rows per second, while ClickPipes processed about 50,000 rows per second: its latency followed the configured sync interval below that rate, then grew as writes exceeded capacity. Row counts and checksums matched across source and destinations. With WalShadow, the author also found that application writes, schema changes, restarts, and resizes continued replicating without manual intervention. Practical caveats include temporary cross-table inconsistency within a transaction, handling row versions and deletes in materialized views, fixed metadata values on initial-load rows, and delays behind large transactions. ClickPipes supports external Postgres sources and offers pause/resume, logs, and destination-stop email alerts; WalShadow was tested only on Managed Postgres and required checking console status to detect stopped replication. Results reflect private-preview behavior and may change.

### Source excerpt

Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.

## ClickHouse release 26.10

DevFeed: [ClickHouse release 26.10](<https://devfeed.tech/articles/clickhouse-release-26-10-121768.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhouse-release-26-10>)

Author: ClickHouse

Published: 2026-11-06T11:45:40Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [Release notes](<https://devfeed.tech/topics/release-notes.md>), [Cache](<https://devfeed.tech/topics/cache.md>), [Functional programming](<https://devfeed.tech/topics/functional-programming.md>)

Tags: [cache](<https://devfeed.tech/tags/cache.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [composition](<https://devfeed.tech/tags/composition.md>), [experimental](<https://devfeed.tech/tags/experimental.md>), [faster](<https://devfeed.tech/tags/faster.md>), [flexible](<https://devfeed.tech/tags/flexible.md>), [freeform](<https://devfeed.tech/tags/freeform.md>), [function](<https://devfeed.tech/tags/function.md>), [more](<https://devfeed.tech/tags/more.md>), [release](<https://devfeed.tech/tags/release.md>)

### AI overview

ClickHouse 26.10 adds SQL composition with `|`, quota limits on inserted rows, and new array and map functions. Integer division can optionally truncate toward zero through `sql_compatible_division_for_integers`; that setting is off by default, errors on division by zero, and does not change stored views. Large `IN` subquery sets can spill to disk, enabling the example query to run under a 512 MiB limit with a 128 MiB spill threshold and 203 MiB peak use. Benchmarks report faster grouping by multiple `LowCardinality` columns and about 94% fewer rows read for Top-K grouped queries with dynamic filtering. The experimental columns cache reuses decoded column data (the example's repeated query falls from 32-34 ms to 12 ms); it currently supports wide MergeTree parts. Experimental `LATERAL JOIN` requires enabling a setting. Arbitrary `JOIN` conditions support patterns such as `LIKE`, but may use a block nested loop as slow as a cross join. The release also adds Freeform text input, SQLite input/output formats, and string filtering during scans; the example reports similar time but peak memory falling about 98%.

### Source excerpt

ClickHouse 26.10 introduces function composition, more flexible joins, faster GROUP BY queries, disk spilling for IN subqueries, an experimental columns cache, and Freeform and SQLite formats.

## MongoDB CDC connector for ClickPipes is now generally available

DevFeed: [MongoDB CDC connector for ClickPipes is now generally available](<https://devfeed.tech/articles/mongodb-cdc-connector-for-clickpipes-is-now-generally-available-117630.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/mongodb-cdc-connector-clickpipes-ga>)

Author: Marta Paes

Published: 2026-11-04T17:46:41Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [MongoDB](<https://devfeed.tech/topics/mongodb.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [releases](<https://devfeed.tech/topics/releases.md>), [Prometheus](<https://devfeed.tech/topics/prometheus.md>), [OpenAPI Specification](<https://devfeed.tech/topics/openapi.md>)

Tags: [cdc](<https://devfeed.tech/tags/cdc.md>), [lag](<https://devfeed.tech/tags/lag.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [openapi](<https://devfeed.tech/tags/openapi.md>), [parallel](<https://devfeed.tech/tags/parallel.md>), [resource](<https://devfeed.tech/tags/resource.md>), [structured](<https://devfeed.tech/tags/structured.md>), [terraform](<https://devfeed.tech/tags/terraform.md>)

### AI overview

MongoDB CDC ClickPipes is generally available for ClickHouse Cloud, using MongoDB Change Streams for near-real-time replication. GA adds automatic parallel snapshots partitioned by `_id`, with sampled boundaries to balance uneven collections. Structured ingestion is optional: it infers a schema and maps top-level fields to typed columns; unknown fields and type mismatches are retained in `_peerdb_malformed_data`. Deeper flattening is not yet supported. Users can configure target fields, partitioning, sorting keys, enable collection pre-images for deletes, or filter deletes to retain history. New CPU, memory, network, and source, destination, and end-to-end lag metrics are available in the UI and Prometheus endpoint. OpenAPI and Terraform management require Terraform v3.14.0 or later. Billing began November 4, 2026; the connector is available in all ClickHouse Cloud service tiers.

### Source excerpt

The MongoDB CDC connector for ClickPipes is now generally available, with parallel snapshotting, structured ingestion into typed columns, lag and resource metrics, and Terraform and OpenAPI support.

## Fencing a Postgres primary that might still be alive

DevFeed: [Fencing a Postgres primary that might still be alive](<https://devfeed.tech/articles/fencing-a-postgres-primary-that-might-still-be-alive-117629.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/fencing-a-postgres-primary-that-might-still-be-alive>)

Author: Furkan Sahin

Published: 2026-11-04T00:30:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [control-plane](<https://devfeed.tech/topics/control-plane.md>), [read-replica](<https://devfeed.tech/topics/read-replica.md>), [hosting](<https://devfeed.tech/topics/hosting.md>), [communications](<https://devfeed.tech/topics/communications.md>), [TTL in DNS](<https://devfeed.tech/topics/ttl-in-dns.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [async](<https://devfeed.tech/tags/async.md>), [availability](<https://devfeed.tech/tags/availability.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bare-metal](<https://devfeed.tech/tags/bare-metal.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [control-plane](<https://devfeed.tech/tags/control-plane.md>), [dns](<https://devfeed.tech/tags/dns.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [ec2](<https://devfeed.tech/tags/ec2.md>), [egress](<https://devfeed.tech/tags/egress.md>), [fencing](<https://devfeed.tech/tags/fencing.md>), [gcp](<https://devfeed.tech/tags/gcp.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [primary](<https://devfeed.tech/tags/primary.md>), [standby](<https://devfeed.tech/tags/standby.md>)

### AI overview

Promoting a Postgres standby and refreshing DNS do not stop writes to an old primary that remains reachable, so fencing is needed before promotion to reduce split brain risk. The control plane tries fencing methods in parallel to limit downtime. With guest SSH access, it can stop Postgres or replace pg_hba.conf, though stopping may be undone by reboot and HBA rules affect only new connections. Bare metal fencing takes down the VM's host-side veth, cutting all network traffic; it depends on the host being reachable. AWS fencing force-detaches a dedicated user NIC, since the primary NIC cannot be detached while running and security groups leave tracked connections active. GCP fencing deletes a Dynamic NIC; measured last-packet delays were 0.7-2.5 seconds, with the API completing in 5-7 seconds. If every method fails, the standby still promotes: the design deliberately favors availability over waiting for a confirmed fence.

### Source excerpt

Promoting a standby doesn't stop the old Postgres primary from taking writes. Here's how the control plane behind ClickHouse Managed Postgres fences it on bare metal, AWS and GCP, and why the design is fail-open.

## What's new in ClickStack - September and October '26

DevFeed: [What's new in ClickStack - September and October '26](<https://devfeed.tech/articles/what-s-new-in-clickstack-september-and-october-26-115492.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/whats-new-in-clickstack-october-2026>)

Author: The ClickStack Team

Published: 2026-11-03T19:09:52Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [Prometheus](<https://devfeed.tech/topics/prometheus.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [health check](<https://devfeed.tech/topics/health-check.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [about](<https://devfeed.tech/tags/about.md>), [added](<https://devfeed.tech/tags/added.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [collector](<https://devfeed.tech/tags/collector.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [explorer](<https://devfeed.tech/tags/explorer.md>), [improvements](<https://devfeed.tech/tags/improvements.md>), [list](<https://devfeed.tech/tags/list.md>), [logs](<https://devfeed.tech/tags/logs.md>), [october](<https://devfeed.tech/tags/october.md>), [query](<https://devfeed.tech/tags/query.md>), [releases](<https://devfeed.tech/tags/releases.md>), [search](<https://devfeed.tech/tags/search.md>), [trace](<https://devfeed.tech/tags/trace.md>), [tracing](<https://devfeed.tech/tags/tracing.md>), [type](<https://devfeed.tech/tags/type.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

ClickStack v2.39-v2.42 added interactive ad hoc dashboard filters, expanded PromQL across chart types and the dashboards API, and query attribution that identifies the ClickStack surface responsible for ClickHouse load. Dashboard updates include required and single-select variables, saved relative time ranges, and PromQL heatmap modes; PromQL remains experimental and requires enablement, with ClickHouse 26.8 or newer recommended for self-managed servers. Search, trace, and alert workflows gained filtering, trace logs, chart-explorer alerts, and richer webhook validation and templates. The collector now offers opt-in StatsD and span-metrics components configured through a custom pipeline. For authenticated self-hosted deployments, upgrades require explicitly setting EXPRESS_SESSION_SECRET.

### Source excerpt

The September and October ClickStack releases bring ad hoc dashboard filters, PromQL for every chart type, ClickStack query tracing, a Trace logs tab, alerts from the chart explorer, and a long list of search page and collector improvements.

## Does your application need local data or faster Postgres?

DevFeed: [Does your application need local data or faster Postgres?](<https://devfeed.tech/articles/does-your-application-need-local-data-or-faster-postgres-115491.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/does-your-application-need-local-data-or-faster-postgres>)

Author: Lionel Palacin; Gülçin Yıldırım Jelínek

Published: 2026-11-03T14:55:13Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [database-optimization](<https://devfeed.tech/topics/database-optimization.md>), [copy](<https://devfeed.tech/topics/copy.md>), [consistency](<https://devfeed.tech/topics/consistency.md>), [Local AI](<https://devfeed.tech/topics/local-ai.md>), [Rockset](<https://devfeed.tech/topics/rockset.md>), [API](<https://devfeed.tech/topics/api.md>)

Tags: [agents](<https://devfeed.tech/tags/agents.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-agents](<https://devfeed.tech/tags/ai-agents.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [application](<https://devfeed.tech/tags/application.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [complexity](<https://devfeed.tech/tags/complexity.md>), [connection-pooling](<https://devfeed.tech/tags/connection-pooling.md>), [consistency](<https://devfeed.tech/tags/consistency.md>), [copy](<https://devfeed.tech/tags/copy.md>), [nvme](<https://devfeed.tech/tags/nvme.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [synchronization](<https://devfeed.tech/tags/synchronization.md>)

### AI overview

The article recommends measuring whether a central Postgres database meets latency and throughput needs before adding local synchronization. Sync engines use logical replication to maintain declared subsets in local stores, making covered reads local, but add lifecycle and write-reconciliation work; they suit offline use and predictable, reused working sets. AI agents make subsets harder to predict, so broad or changing sync can transfer unused data or put remote fetches back in the read path. ClickHouse Managed Postgres is presented as a faster central option using attached NVMe, with read replicas for scaling reads. NVMe does not fix inefficient queries, so pooling, query tuning, and concurrency controls still matter. For durability, up to two cross-zone standbys are supported: two use synchronous replication, while one is asynchronous; WAL archiving and backups support recovery. For analytics, WalShadow is in private preview with roughly 200 ms commit-to-visible latency, and pg_clickhouse requires configured foreign tables and supported query pushdown; it does not automatically route every query.

### Source excerpt

Local synchronization makes reads fast, but adds another data layer to manage. Explore how AI agents change the trade-off and when NVMe-backed Postgres can simplify the architecture.

## What's new in clickhousectl v0.5.0

DevFeed: [What's new in clickhousectl v0.5.0](<https://devfeed.tech/articles/what-s-new-in-clickhousectl-v0-5-0-112338.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/clickhousectl-v0-5-0>)

Author: Al Brown

Published: 2026-11-02T14:45:00Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [control-plane](<https://devfeed.tech/topics/control-plane.md>), [Tool](<https://devfeed.tech/topics/tool.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>), [Handlebars](<https://devfeed.tech/topics/handlebars.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [3](<https://devfeed.tech/tags/3.md>), [account](<https://devfeed.tech/tags/account.md>), [added](<https://devfeed.tech/tags/added.md>), [api](<https://devfeed.tech/tags/api.md>), [api-key](<https://devfeed.tech/tags/api-key.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [command](<https://devfeed.tech/tags/command.md>), [key](<https://devfeed.tech/tags/key.md>), [local](<https://devfeed.tech/tags/local.md>), [managed](<https://devfeed.tech/tags/managed.md>), [needs](<https://devfeed.tech/tags/needs.md>), [observability](<https://devfeed.tech/tags/observability.md>), [permissions](<https://devfeed.tech/tags/permissions.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [surface](<https://devfeed.tech/tags/surface.md>), [takes](<https://devfeed.tech/tags/takes.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

clickhousectl v0.5.0 expands the CLI across local development and ClickHouse Cloud, with executable UDFs as a clear end-to-end workflow: scaffold and test locally, then package, attach, and wake a Cloud service in one deploy command. For ClickHouse Managed Postgres, it adds metrics, logs, slow-query analysis, read-only SQL over HTTP, and IP allow rules; restore carries source IP rules forward to avoid opening access to all addresses. BigQuery ClickPipes now support CDC using query- or events-based replication on intervals or cron schedules, with invalid combinations checked locally before reading the service-account key. The release also adds ClickStack resource management, saved-query HTTP endpoints, broader service, backup, org, and BYOC controls, and consistent resource selectors and JSON errors for automation. Some command spelling changes break existing scripts; old forms fail with a usage error. Cloud command help lists required API-key permissions. The source is a release excerpt and does not provide a complete compatibility or migration guide.

### Source excerpt

clickhousectl v0.5.0 takes UDFs from local to Cloud, adds ClickHouse Managed Postgres observability, standardises the command surface, and lists the API-key permissions every Cloud command needs.

[Next page](<https://devfeed.tech/sources/clickhouse-blog.md?cursor=WyIyMDI2LTExLTAyVDE0OjQ1OjAwKzAwOjAwIiwgIjlhOTUxMWQ0LTBiMDgtNGNjYy1hOWYwLWZjMTkzNDkxMjhmMyJd>)