Bring High-Performance Analytics to Your Lakehouse with ClickHouse and Amazon S3 Tables
ClickHouse, Wednesday, November 11th, 2026
ClickHouse shows how to query and write back to Apache Iceberg data in Amazon S3 Tables without copying it to another system.
The post explains how ClickHouse connects to Amazon S3 Tables through the Iceberg REST endpoint using the DataLakeCatalog database engine, so a table bucket appears as a database inside ClickHouse.
Users can query Iceberg tables in place, run transformations in ClickHouse SQL and write curated results back while S3 Tables remain the single source of truth, which avoids the cost, staleness, governance sprawl and lock-in of data copies.
The walkthrough uses a retail analytics use case with a self-managed ClickHouse deployment and extends the pattern to AI agent workloads.
Authentication uses AWS Signature Version 4 with IAM policies.