ClickHouse release 26.8
ClickHouse 26.8 LTS introduces background queries, pipelined SQL, new text tokenizers, expanded data lake integrations, and faster Parquet, aggregation, and join queries.
Also shipped Sep 10, 2026ClickHouse in September 2026 →
BigQuery conversational analytics adds ML.CORRELATION in preview
Conversational analytics can now use ML.CORRELATION to calculate statistical correlations between a target column and one or more metric columns in a table.
BigQuery ML.METRICS evaluates predictions without a stored model
The preview ML.METRICS function computes classification or regression evaluation metrics on any table or query with actual and predicted values, with no need to create or reference a stored model.
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data
You can use the AI.CAUSAL_EFFECT function to quantify the impact of specific interventions on time series data. This feature is in Preview .
BigQuery Data Engineering Agent integrates with BigQuery Graph
The Data Engineering Agent now uses BigQuery Graph for extra context between source and destination schemas, improving schema mapping accuracy in data engineering pipelines. It is generally available.
Using dbt artifacts for Slim CI and defer to production in dbt Projects on Snowflake (General availability)
Slim CI, defer to production, failed-execution recovery, and concurrent execution are now generally available for dbt Projects on Snowflake. Reuse dbt artifacts from recent production executions to accelerate development, streamline CI/CD workflows, and recover from failed production runs without maintaining a separate artifact store.
External secret providers (Preview)
External secret providers are now in preview. If your organization already keeps API keys, database passwords, and similar values in AWS Secrets Manager, Azure Key Vault, or Google Cloud Secret Manager, Snowflake can read those values when a query needs them, so you don't have to maintain a second copy in a Snowflake secret .
More from ClickHouseEvery ClickHouse release →
Introducing WalShadow: Sub-second Postgres replication to ClickHouse from physical WAL
WalShadow replicates Postgres data directly from physical WAL into ClickHouse, delivering around 200 ms latency and 289,000 rows per second in benchmarks.
ClickHouse is a launch partner for the Data agent in ChatGPT Work
ClickHouse joins the Data agent in ChatGPT Work, connecting ClickHouse Cloud to natural-language queries, reports, and interactive dashboards.
Announcing On-Demand Compute: Instant compute for your most intensive workloads
ClickHouse On-Demand Compute lets you scale individual queries with additional workers, run intensive workloads without disrupting production, and use compute when you need it.
Announcing ClickHouse Managed Postgres on Google Cloud
ClickHouse Managed Postgres is expanding to Google Cloud, bringing NVMe-backed storage, native CDC into ClickHouse, and a unified query layer via pg_clickhouse to GCP private preview customers.
Introducing chdb Postgres extension: High-performance imports from cloud storage
The chdb Postgres extension brings fast imports and exports across cloud storage platforms and data formats, powered by the embedded ClickHouse engine.
Introducing ClickHouse's new TimeSeries Engine: Your drop-In Prometheus replacement
ClickHouse PromQL support lets you store Prometheus metrics in ClickHouse Cloud, query them using familiar PromQL, and bring metrics together with your logs and traces without rewriting queries in SQL.
Replica-aware routing public beta
Temporary tables and named sessions live on a single ClickHouse replica, so a follow-up query routed elsewhere can't see them. Replica-aware routing pins your requests to the same replica over HTTP or the native protocol , and here's how we built it.
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.