Releasesby GlyphClickHouse release 26.9
ClickHouse 26.9 introduces conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for DISTINCT queries, time-limited tokens, and query optimizations for min, max, and count operations.
Also shipped Sep 23, 2026ClickHouse in September 2026 →
New features and improvements in Copilot for JetBrains
GitHub Copilot for JetBrains 1.18.0 brings AI-assisted tool approvals, more control over agent conversations, and shared skills and instructions for your organization. You can also review plans with the Codex agent and manage MCP tools with persistent controls.
Scalar and Batch Unity Catalog Python UDFs are now generally available
Scalar and Batch Unity Catalog Python UDFs are now generally available on all supported compute types. This release adds named handlers for row-at-a-time scalar UDFs, removes the five-UDF-call-per-query limit, and aligns scalar TIMESTAMP inputs with PySpark behavior.
Build governed data and AI apps without code (Beta)
You can now build governed data and AI apps without code. Genie App Builder authors apps in natural language, App Spaces enforce governance, and Serverless Micro Apps scale to zero when idle. See Governed agentic app building .
Non-deterministic aggregate functions are supported with dynamic table incremental refresh (General availability)
Non-deterministic aggregate functions such as approx count distinct , approx percentile , and approx top k are now supported with dynamic table incremental refresh in INCREMENTAL, AUTO, and ADAPTIVE refresh modes. For incremental refresh, these functions are supported only in the SELECT clause. any value remains unsupported.
More ways to request and configure Copilot code reviews
GitHub Copilot code review now offers additional personal configurations to an expanded set of Copilot plans and an enterprise-level default setting. These improvements are now generally available: A dedicated personal settings page for automatic review and your default review effort An enterprise-wide default review effort setting for organization-owned...
Node 20 is no longer available in GitHub Actions
This is the final notification that Node 20 is no longer available on GitHub Actions runners. Runners now use Node 24 for JavaScript actions. The temporary ACTIONS_ALLOW_USE_UNSECURE_NODE_VERSION opt-out is no longer available. If you maintain a JavaScript action, update its runs.using value to node24 and publish a new release as soon as possible.
More from ClickHouseEvery ClickHouse release →
chDB Durable Layer for agent memory
ClickHouse introduced the chDB Durable Layer, which keeps agent memory fast to query locally while making its analytical state recoverable across environments.
ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview
ClickHouse Workload for Microsoft Fabric is now in public preview, enabling sub-second analytics on OneLake data. It provides dedicated compute for dashboards, agents, and applications.
ClickHouse now writes Apache Iceberg tables to Microsoft OneLake
ClickHouse now supports writing data directly to Microsoft OneLake. This integration allows users to store and manage analytical data within the Fabric ecosystem.
ClickHouse expands collaboration with Microsoft, bringing Fabric integration, deeper OneLake interoperability, and enterprise deployment flexibility
ClickHouse announced a native Fabric workload, OneLake read and write capabilities, and the availability of ClickHouse BYOC in the Microsoft Marketplace.
The official ClickHouse provider for Apache Airflow is now available
The official ClickHouse provider for Apache Airflow simplifies data workflows with standard SQL operators, bulk inserts, and shared setup across self-managed Airflow and Astronomer.
Introducing SCIM Provisioning in ClickHouse Cloud
ClickHouse Cloud now supports SCIM 2.0 for automated user and group management. This allows identity providers to synchronize member creation, updates, and role assignments directly to ClickHouse.
pg_clickhouse & chdb updates: Encoding, nesting, and types
The latest releases of the pg_clickhouse and chdb extensions improve character encoding, interval handling, nested data, JSON, and type mappings between ClickHouse and Postgres.
ClickHouse is now available on the dbt platform
The ClickHouse adapter for dbt v2 is in public beta, powered by dbt’s Rust engine. ClickHouse also joins the dbt platform in private beta, supporting open-source ClickHouse and ClickHouse Cloud.