ClickHouse logo

How ClickHouse Uses SQL

262 engineering articles about SQL from ClickHouse's engineering team

Articles

Filter:
ClickHouse logo
ClickHouse
Intermediate
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.
15 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Connect TimesFM to ClickHouse with executable UDFs to forecast retail demand, detect anomalies, and account for known future events using SQL.
13 min read
Includes Code
--
ClickHouse logo
ClickHouse
Beginner
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.
3 min read
--
ClickHouse logo
ClickHouse
Advanced
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 logo
ClickHouse
Intermediate
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.
9 min read
--
ClickHouse logo
ClickHouse
Intermediate
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.
26 min read
Includes Code
--
ClickHouse logo
ClickHouse
Beginner
Hidehiko ASAHI shares a month of WalShadow private-preview testing, comparing replication latency with ClickPipes and checking data correctness, schema changes, and recovery.
ClickHouse logo
ClickHouse
Intermediate
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.
ClickHouse logo
ClickHouse
Intermediate
OpenRouter uses ClickHouse Cloud as the single store behind customer analytics, public model rankings, internal AI agents, and routing across 500+ models, as monthly requests grew 33x to 19.7 billion.
9 min read
--
ClickHouse logo
ClickHouse
Advanced
Meet GroeneAI, ClickHouse’s autonomous engineering agent that contributed more than 3,000 merged pull requests in under seven months.
ClickHouse logo
ClickHouse
Advanced
Explore how ClickHouse Cloud turns fresh data into fast answers with efficient preparation, parallelized queries, and elastic scaling.
26 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickHouse’s new exhaustive cost-based join optimizer safely reorders inner, outer, semi, and anti joins to find the cheapest valid plan.
19 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Jev ranks warehouse tables and labels agent failures in under a second, but adding retrieval hints leaves accuracy flat across 20 models on the Agentic Analytics Benchmark.
18 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
NVIDIA Vera tops the ClickBench hardware leaderboard, and three micro-benchmarks for filters, aggregation and joins show ClickHouse scaling almost linearly across its 176 cores.
12 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Connect Cursor to Langfuse to trace every agent turn, pinpoint expensive model and tool calls, and use evaluations to confirm a fix actually helps, with ClickHouse powering the analytics underneath.
6 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
We added GPT-6 Astra, Luna and Sol, Claude Opus 5.5 and Claude Sonnet 5.5 to the Agentic Analytics Benchmark: all five land mid-board within a point of each other, and Sonnet 5.5 brings the biggest change in turns, cost and truncated runs.
ClickHouse logo
ClickHouse
Advanced
Offload settled Postgres data to ClickHouse to reduce storage and query costs while keeping active transactions in Postgres.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse Cloud delivered 1,996× better performance per dollar than Redshift Serverless in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
24 min read
--
ClickHouse logo
ClickHouse
Advanced
Ridgeline rebuilt its performance analytics on ClickHouse Cloud, querying decades of Iceberg history alongside recent data so it can serve investment managers 10x larger than before and more than double the customers live on its platform.
ClickHouse logo
ClickHouse
Advanced
A customer saw an extra ~32 ms on simple SELECT queries after idle periods. We traced it to unbatched Native protocol metadata packets overflowing a reset TCP congestion window, reproduced it with network namespaces, and fixed it by batching them.
12 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
At Open House NYC, we showed how ClickHouse Managed Postgres and ClickHouse work as one stack, with a live WalShadow demo replicating Postgres into ClickHouse in under a second, plus the same-week Google Cloud and chdb extension launches.
ClickHouse logo
ClickHouse
Advanced
ClickHouse Cloud delivered 438× better performance per dollar than BigQuery in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
23 min read
--
ClickHouse logo
ClickHouse
Beginner
Highlights from Postgres Summit US 2026 in New York City, where ClickHouse sponsored the community and demonstrated its growing Postgres integrations.
ClickHouse logo
ClickHouse
Advanced
ClickHouse Cloud delivered 752× better performance per dollar than Databricks in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
ClickHouse logo
ClickHouse
Advanced
Executable UDFs are now generally available on ClickHouse Cloud across AWS, GCP, and Azure, with native runtimes, network access, observability, and API and Terraform support.
ClickHouse logo
ClickHouse
Advanced
LinkedIn expanded its ClickHouse observability stack from distributed tracing to metric discovery and analytics, consolidating 13B+ metrics into one index serving 150k+ queries per minute.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse Workload for Microsoft Fabric brings sub-second analytics to OneLake data through a native Fabric workload, with dedicated ClickHouse Cloud compute for agents, dashboards, and applications.
ClickHouse logo
ClickHouse
Advanced
The chDB Durable Layer keeps agent memory fast to query locally while making its analytical state recoverable across laptops, CI jobs, and short-lived sandboxes.
16 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
How do Postgres providers handle a query that exhausts memory? A recursive query benchmark compares query failures and cluster survival across ClickHouse Managed Postgres, Cloud SQL, PlanetScale, and Amazon RDS.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse 26.9 introduces conditional LIMIT boundaries, incremental refreshes for append-only materialized views, disk spilling for DISTINCT, time-limited tokens, and faster min/max/count queries.
21 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
See how local NVMe transforms Postgres transaction performance—and why ClickHouse remains essential for fast analytics as workloads scale.
9 min read
Includes Code
--
ClickHouse logo
ClickHouse
Beginner
Notes from three days in the Netherlands, featuring a lightning talk on pg_clickhouse and pg_stat_ch at PGDay Lowlands and a session on PostgreSQL 19 monitoring at Percona Live Amsterdam.
8 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
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.
7 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
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.
13 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickHouse 26.8 LTS introduces background queries, pipelined SQL, new text tokenizers, expanded data lake integrations, and faster Parquet, aggregation, and join queries.
ClickHouse logo
ClickHouse
Intermediate
Use ClickHouse to load Parquet files into MySQL, explore remote data, and run MySQL queries with table functions and named collections.
7 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Explore ClickHouse AI Functions for classification, generation, translation, embeddings, semantic search, and cost controls—all directly from SQL.
14 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
CostBench puts cloud data warehouses under continuous load. Across the complete path from fresh data to fast answers, ClickHouse Cloud delivers 412–1,996× better performance per dollar.
20 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Google's MCP Toolbox for Databases embeds agent text into vectors on insert and search, then lets ClickHouse rank the results - no embedding service to build or maintain. Here's how to set it up, and what it looks like end to end.
ClickHouse logo
ClickHouse
Intermediate
Learn how to build a streaming HTTP API directly in ClickHouse 26.8 with named handlers, typed parameters, pagination, framing formats, and access control.
19 min read
Includes Code
--
ClickHouse logo
ClickHouse
Beginner
PostgreSQL 19 adds four system views that make lock contention, recovery state, autovacuum priorities, and dynamic shared memory allocations easier to inspect.
14 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
We took 201 real analytics questions from our production data warehouse, benchmarked 28 models on correctness, cost, and speed, and released an open harness so you can run the same test on your own.
ClickHouse logo
ClickHouse
Beginner
See how a four-step onboarding flow helps users move from provisioning ClickHouse Managed Postgres to querying operational data and running real-time analytics with ClickHouse.
7 min read
--
ClickHouse logo
ClickHouse
Advanced
After claims that ClickHouse is “winning the observability wars” sparked debate, we reflect on why it has become a leading storage and query engine, where it still falls short, and why winning the database layer isn’t the same as winning observability.
ClickHouse logo
ClickHouse
Advanced
Discover how ClickHouse .NET Driver 1.1–1.3 adds type-safe POCO workflows, extensible serialization, broader type support, performance improvements, and official ecosystem integrations.
16 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickGap reviews merged ClickHouse changes, executes reproducers, rejects false positives, and attributes regressions to specific commits.
22 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.
7 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Suprema Gaming migrated its analytics platform from Snowflake to ClickHouse Cloud to power a company-wide shift toward agentic operations.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse Grafana plugin 4.20 brings compact query mode, click-to-filter log investigation, guided variable and annotation editors, and OpenTelemetry dashboards
7 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
iFood rebuilt its in-house security platform on ClickHouse Cloud, getting 9-16x faster queries at 40-50% of the cost and unlocking agentic threat hunts that cut a week of analyst work down to two hours.