ClickHouse integrates with Lakehouse Runtime Catalog
Blog post from ClickHouse
The integration between ClickHouse and Google's Lakehouse Runtime Catalog enables direct querying of Google Cloud Lakehouse Iceberg tables in ClickHouse via the Apache Iceberg REST Catalog, initially as a beta feature in ClickHouse 26.2 and soon in ClickHouse Cloud. This development addresses the challenge of data accessibility across different storage systems by allowing interoperability with various Iceberg-compatible engines like BigQuery, Apache Spark, Trino, and now ClickHouse. Utilizing the integration requires a ClickHouse instance and a Google Cloud project with Lakehouse Runtime Catalog enabled, allowing ClickHouse to connect to the Iceberg REST Catalog API for data discovery and querying without data movement or additional connectors. Authentication is facilitated through Google's Application Default Credentials (ADC), and the integration supports querying and loading data into ClickHouse's native format for fast analytics. Future enhancements include write support for Google Cloud Lakehouse Iceberg tables and an improved user interface in ClickHouse Cloud to streamline connections and data queries.