ClickHouse logo

How ClickHouse Uses AWS

115 engineering articles about AWS from ClickHouse's engineering team

Articles

Filter:
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
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
Beginner
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.
11 min read
Includes Code
--
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
Intermediate
ClickHouse’s new native TCP client for .NET brings faster reads and inserts with fewer allocations, columnar APIs, POCO support, and a path to migrate from HTTP.
18 min read
Includes Code
--
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
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
Intermediate
iSAM Funds uses ClickHouse Cloud to research full options history, achieving 35–50x compression and 100x faster single-core ingestion while simplifying its data pipelines.
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
Intermediate
ClickHouse Managed Postgres uses direct I/O and stripe-sized reads to keep backups fast while protecting the page cache and query latency.
18 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
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
ClickHouse Cloud delivered 412× better performance per dollar than Snowflake in CostBench. We trace the gap from fresh data arriving to fast answers coming back.
33 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
Suprema Gaming migrated its analytics platform from Snowflake to ClickHouse Cloud to power a company-wide shift toward agentic operations.
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.
ClickHouse logo
ClickHouse
Intermediate
This release brings speedups for GROUP BY ... ORDER BY ... LIMIT, three JOIN improvements, four vector search improvements, position-aware phrase search, EXPLAIN ANALYZE, unified URL access, and more!
34 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
You can choose any of these hundred database systems and run queries. You can create tables and databases, insert data, drop tables, etc. Every database comes with a preloaded dataset of 100 million records, so you can test example queries. It has not onl
ClickHouse logo
ClickHouse
Advanced
We ran ClickHouse Managed Postgres and PlanetScale on the same hardware. ClickHouse delivered up to 54% higher throughput with lower latency.
5 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickHouse has achieved the AWS Small and Medium Business Competency, joining a select group of AWS Partners recognized for deep expertise in real-time analytics for small and medium businesses.
ClickHouse logo
ClickHouse
Intermediate
PostgresBench now includes HA benchmarks, comparing the performance of managed Postgres services under production-style HA configurations. This post explains the architectures behind each service and analyzes the trade-offs between availability guarantees
8 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Recent improvements to the OpenTelemetry Collector's Datadog receiver let teams reroute telemetry from their existing Datadog agents and SDKs to ClickStack. or any OTel destination making migrations and evaluations simpler than ever.
ClickHouse logo
ClickHouse
Intermediate
This post shows a lightweight metrics layer for ClickHouse using MooseStack, an open source developer agent harness for ClickHouse.
ClickHouse logo
ClickHouse
Advanced
ClickHouse 26.2 is here! In this post, text-index and QBit data type become production-ready.
14 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
How to remain competitive in the AI era of software engineering
ClickHouse logo
ClickHouse
Intermediate
Discover how Postgres managed by ClickHouse compares to its peers in a reproducible, open benchmark.
ClickHouse logo
ClickHouse
Advanced
ClickHouse now brings full-text search and large-scale analytics together in one engine, making it a powerful alternative to Elasticsearch for log analytics. This benchmark shows why.
24 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
We use clickhousectl to spin up multiple ClickHouse versions side by side and benchmark two recent performance improvements.
11 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickHouse 26.5 is here! In this release, we have a record number of performance optimizations, a new `filesystem` table function for querying your local file system with SQL, and more!
17 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
ClickHouse Cloud takes on Snowflake, Databricks, BigQuery, and Redshift on TPC-H, ranking first on SF100 cost-performance and running SF10 for less than one cent.
8 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Over two years of focused join engineering, ClickHouse became 26× faster on the TPC-H SF100 join-heavy workload. Here’s how parallel hash joins, runtime filters, lazy column replication, and smarter join planning got us there.
17 min read
Includes Code
--
ClickHouse logo
ClickHouse
Intermediate
Postgres managed by ClickHouse's first major update since public beta, covering fine-grained access control, a redesigned console, Terraform support, MCP integration, Stripe provisioning, migrations, billing, and capacity reservations — all shipped in und
8 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Real-time analytics is more than fast queries. CostBench compares Snowflake and ClickHouse Cloud across the full path: continuous ingest, query-ready data maintenance, freshness, query latency, and cost.
34 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
We scaled our internal logging platform from 19 PiB to 431 PiB and 1.59 quadrillion rows. Here’s how we rearchitected LogHouse to handle 80 GiB/s of writes while keeping queries fast and the underlying complexity invisible.
23 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
chDB embeds a full ClickHouse query engine inside an agent's own process, turning data access, memory, and federation into local function calls instead of network round trips, cutting the latency, retries, and token waste that come with remote queries.
ClickHouse logo
ClickHouse
Intermediate
ClickHouse is now available as a Docker Hardened Image: a minimal, security-hardened build that passes enterprise vulnerability scans by shipping only what the database needs to run, with no change to how ClickHouse behaves.
6 min read
Includes Code
--
ClickHouse logo
ClickHouse
Advanced
Welcome to the July 2026 ClickHouse newsletter, which will round up what’s happened in real-time data warehouses over the last month.
ClickHouse logo
ClickHouse
Intermediate
The article discusses how PeerDB facilitates large-scale PostgreSQL migrations, specifically achieving a 1TB migration in just 2 hours.
15 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Beginner
This article explains how ClickHouse optimizes Top-N queries (ORDER BY . LIMIT N) using granule-level data skipping indexes.
Tom Schreiber
10 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
ClickHouse 25.
20 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Beginner
ClickHouse 25. 9 introduces streaming secondary indices, a fundamental change to how secondary indexes (minmax, set, bloom filter, vector, text) are evaluated during query execution.
Tom Schreiber
5 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Beginner
The article discusses the new functionality in ClickHouse that allows for multiple lightweight projections to behave like true secondary indexes, significantly enhancing query performance without d...
Tom Schreiber
7 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
The article discusses the development of chDB, a Python library that integrates ClickHouse with Pandas DataFrames for high-performance SQL querying.
Xiaozhe Yu Auxten Wang
10 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
ClickHouse version 25. 11 introduces significant enhancements, including 24 new features, 27 performance optimizations, and 97 bug fixes.
The ClickHouse Team
16 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
This article benchmarks five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, BigQuery, and Redshift—across various scales of data to compare their cost-performance.
Tom Schreiber & Lionel Palacin
16 min read
Includes Code
Has Summary
--
ClickHouse logo
ClickHouse
Intermediate
This article provides a detailed analysis of how the five major cloud data warehouses—Snowflake, Databricks, ClickHouse Cloud, Google BigQuery, and Amazon Redshift Serverless—calculate compute cost...
Tom Schreiber & Lionel Palacin
27 min read
Has Summary
--
ClickHouse logo
ClickHouse
Advanced
This article discusses the transition from OpenTelemetry (OTel) to Rotel, an open-source Rust project that enhances tracing capabilities at petabyte scale.
28 min read
Includes Code
Has Summary
--