**San Francisco, CA — November 18, 2025 — ClickHouse Inc.**, the company behind one of the world’s fastest and most popular real-time analytics databases, today announced the availability of a powerful new integration with [Microsoft OneLake](https://learn.microsoft.com/en-us/fabric/onelake/onelake-overview), the unified data lake of Microsoft Fabric.

This integration enables organizations to harness the scale, governance, and simplicity of OneLake with the speed and flexibility of ClickHouse for real-time, large-scale analytical workloads. Learn more in our [technical post](http://www.clickhouse.com/blog/clickhouse-integrates-with-microsoft-onelake).

## Expanding the ClickHouse-Microsoft collaboration

Following the general availability of [ClickHouse Cloud on Microsoft Azure](https://clickhouse.com/blog/clickhouse-cloud-is-now-generally-available-on-microsoft-azure), recent performance enhancements of ClickHouse on Azure Blob Storage, and [a steady series of new capabilities](https://clickhouse.com/blog/a-year-of-clickhouse-cloud-on-azure), this integration with Microsoft OneLake marks the latest milestone in ClickHouse’s growing collaboration with Microsoft.

This initiative reinforces ClickHouse’s commitment to deep interoperability across Microsoft’s data ecosystem. From Azure to Fabric, the goal is to enable real-time analytics within a unified platform for Microsoft customers.

## Improved interoperability between ClickHouse and Microsoft OneLake

Organizations are increasingly unifying their data with a lakehouse architecture, a flexible foundation that supports best-of-breed tools across workloads, from large-scale analytics with ClickHouse to emerging GenAI and AI agent use cases and more. By storing data in open table formats such as Apache Iceberg or Delta Lake, teams ensure accessibility and interoperability across engines, including ClickHouse, so they can always use the right tool for the job.

The ClickHouse integration with OneLake Table APIs exposes Iceberg tables to ClickHouse, allowing users to directly access and analyze their data, facilitating federated and unified analytics across both ClickHouse and Fabric.

Facilitating real-time analytics with ClickHouse

A common challenge for databases is simplifying how data is ingested into the system itself. This new integration gives Fabric customers powerful new options to query critical data in low latency and high concurrency from OneLake with ClickHouse, enabling new workloads such as real-time analytics, operational dashboards, and agent-facing analytics.

“Microsoft OneLake is a very popular data lake solution among our users, and we’ve long wanted to provide a direct integration to enhance their experience, especially by simplifying data movement and analysis. With the introduction of Table APIs in OneLake, we were finally able to do just that. ClickHouse can now natively query data stored in OneLake, giving users seamless access to all their data in OneLake with zero friction,” said Alexey Milovidov, Co-Founder and CTO of ClickHouse.

“For data to be useful, it must be interoperable with a range of tools our customers use every day,” said Dipti Borkar, VP & GM for Microsoft OneLake and Fabric Ecosystem. “Customers can now use ClickHouse on data unified by Microsoft OneLake to deliver on some of the most data-intensive use cases, like real-time observability, cybersecurity & fraud detection and AI.”

## *About ClickHouse*
   
ClickHouse is a fast, open-source columnar database management system built for real-time data processing and analytics at scale. Engineered for high performance, ClickHouse Cloud delivers exceptional query speed and concurrency, making it ideal for applications that demand instant insight from massive volumes of data. As AI agents become increasingly embedded in software and are generating far more frequent and complex queries, ClickHouse brings a high-throughput, low-latency engine, purpose-built to meet this challenge. Trusted by leading companies like Sony, Tesla, Anthropic, Memorial Sloan Kettering, Lyft, and Instacart, ClickHouse helps teams unlock insights and drive smarter decisions with a scalable, efficient, and modern data platform. For more information, visit [clickhouse.com](http://clickhouse.com).  
  

ClickHouse today announced the availability of a powerful new integration with Microsoft OneLake, the unified data lake service within Microsoft Fabric.

large_image1.png

medium_image1.png

small_image1.png

thumbnail_image1.png

image1.png

ClickHouse strengthens collaboration with Microsoft through Microsoft OneLake Integration for Seamless Data Interoperability

We’re excited to announce a new integration between ClickHouse and Microsoft OneLake -  Microsoft Fabric’s unified data lake - powered by the OneLake [Tables APIs](https://learn.microsoft.com/en-us/fabric/onelake/table-apis/iceberg-table-apis-overview) and [Apache Iceberg](https://iceberg.apache.org/).

This integration will debut as a beta feature in ClickHouse 25.11 (November release) and will be available shortly after in ClickHouse Cloud.

With this new integration, ClickHouse now supports direct querying of Iceberg tables in OneLake, eliminating friction and unlocking unified, fast analytics across multiple sources. 

## **Building a Unified Analytics and AI Platform**

A common challenge for organizations and in particular data teams is being able to use all of their data, regardless of where it’s stored for analytics, GenAI and AI agents. Discovery, governance and access controls are critical to successfully delivering on these projects. Making sure they work with all data assets in various data lakes, data warehouses and operational stores is very difficult. 

Microsoft OneLake enables organizations to unify their data into a common store, cataloging and securing it in a single place. They can use [OneLake Shortcuts](https://learn.microsoft.com/en-us/fabric/onelake/onelake-shortcuts) to connect external stores like [Amazon S3](https://learn.microsoft.com/en-us/fabric/onelake/create-s3-shortcut) or [Google Cloud Storage](https://learn.microsoft.com/en-us/fabric/onelake/create-gcs-shortcut) to OneLake, moving data only when it is queried. They can also continuously replicate data from popular databases using native [zero-copy mirroring](https://learn.microsoft.com/en-us/fabric/mirroring/overview) or build their own with [Open Mirroring](https://learn.microsoft.com/en-us/fabric/mirroring/open-mirroring). All of this data is cataloged in the [OneLake catalog](https://learn.microsoft.com/en-us/fabric/governance/onelake-catalog-overview) and secured using [OneLake Security](https://learn.microsoft.com/en-us/fabric/onelake/security/get-started-security) so it can be safely accessed from Microsoft Fabric, [Azure AI Foundry](https://azure.microsoft.com/en-us/products/ai-foundry) and many popular 3rd party engines like ClickHouse.

OneLake’s Iceberg-compatible [Tables APIs](https://learn.microsoft.com/en-us/fabric/onelake/table-apis/iceberg-table-apis-overview) make it possible for ClickHouse to discover and query data in OneLake with minimal configuration. The ease of use and ecosystem interoperability enable a unified analytical platform that combines flexibility and control to empower users to build and deliver analytics and AI projects quickly with all of their data - enterprise, operational, logs, and 3rd party.

## **How does the integration work?** 

To use this new integration, you only need two components:

- A ClickHouse instance (even [ClickHouse local](https://clickhouse.com/docs/operations/utilities/clickhouse-local) will suffice)  
- A [Microsoft Fabric account](https://www.microsoft.com/en-us/microsoft-fabric/getting-started)

Tables can be written into OneLake using Fabric managed engines like [Spark](https://learn.microsoft.com/en-us/fabric/data-engineering/runtime) or [Data Warehouse](https://learn.microsoft.com/en-us/fabric/data-warehouse/) or your tool of choice. You can write tables in either Delta Lake or Apache Iceberg format. OneLake’s format virtualization will automatically convert between formats and keep both in sync at all times, making it easy to bring your engine of choice without converting or migrating your data.

OneLake also exposes an Iceberg REST catalog via OneLake Table APIs, which ClickHouse uses as an interface to discover and query the underlying Iceberg tables directly.

![onelake_image1.png](/uploads/onelake_image1_01d3a18aa2.png)

For security, ClickHouse uses Microsoft Entra ID (formerly Azure Active Directory) to authenticate the user identity with the OneLake Table APIs, ensuring secure and controlled access to data stored in OneLake. Additionally, the same access token received from Entra will be used to allow users the ability to read data from OneLake. Access permissions are managed in Entra as [Service Principals](https://learn.microsoft.com/en-us/entra/identity-platform/app-objects-and-service-principals?tabs=browser) or through Fabric [workspace-level permissions](https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-sharing).

## **Getting Started with ClickHouse and OneLake**

Getting started with ClickHouse and OneLake is simple. You can deploy ClickHouse on [Azure](https://clickhouse.com/partners/azure) or directly from the [Azure Marketplace](https://marketplace.microsoft.com/en-us/product/saas/clickhouse.clickhouse_cloud?tab=overview), ensuring you’re using version 25.11. Once your service is deployed, you’ll be able to enable the OneLake integration and run the following queries to access your Iceberg tables directly. Read more in the [ClickHouse documentation for OneLake](https://clickhouse.com/docs/use-cases/data-lake/onelake-catalog).

## **Querying OneLake from ClickHouse**

It is very simple to start querying OneLake using ClickHouse. [Here](http://learn.microsoft.com/en-us/fabric/onelake/table-apis/table-apis-overview#prerequisites), you’ll find a step-by-step guide to obtaining all the information needed to connect ClickHouse to your OneLake Iceberg catalog.

Since this integration is still in beta, you’ll need to also execute the following:

```sql
SET allow_database_iceberg=1
```

### Creating a connection to OneLake

Once the prerequisites are met, you can create a connection to your OneLake Iceberg catalog by running the following command in ClickHouse:

```sql
CREATE DATABASE onelake_catalog   
ENGINE = DataLakeCatalog('https://onelake.table.fabric.microsoft.com/iceberg')   
SETTINGS
  catalog_type = 'onelake',   
  warehouse = 'warehouse_uuid/data_item_uuid',   
  onelake_tenant_id = '<tenant_id>',   
  oauth_server_uri = 'https://login.microsoftonline.com/<tenant_uuid>/oauth2/v2.0/token',   
  auth_scope = 'https://storage.azure.com/.default',   
  onelake_client_id = '<client_id>',   
  onelake_client_secret = '<client_secret>';
```

### Querying OneLake tables

After creating the connection, you can list all the tables available in the catalog:

```sql
SHOW TABLES FROM onelake_catalog;
```

![onelake_image2.png](/uploads/onelake_image2_6dbbc12201.png)


Then, you can query any table directly from ClickHouse:

```sql
SELECT count(*)   
FROM onelake_catalog.`year_2017.green_tripdata_2017`   
WHERE VendorID = 2;
```

![onelake_image3.png](/uploads/onelake_image3_9e0ea8ce49.png)

## **What’s next**

The 25.11 release is just the first step toward deeper integration with the OneLake ecosystem.

We’re already working on several enhancements that will be introduced in upcoming releases, including:

* **General Availability**: Upgrading the feature from beta to GA by improving the overall quality of life, performance, and incorporating user feedback.

* **Write support:** Adding support for writing data back to your Iceberg tables in OneLake.

* **Enhanced cloud integration:** Introducing a new user interface in ClickHouse Cloud to easily create connections to the OneLake catalog and query your data directly from the UI.

![onelake_image4.png](/uploads/onelake_image4_d309e8af1e.png)

With ClickHouse and Microsoft OneLake, customers can leverage their vast data assets, integrated via OneLake native integrations, Shortcuts and Mirroring, to quickly and easily query, perform complex analytics and drive GenAI and AI Agent initiatives with ease. Get started today at [ClickHouse.com](http://clickhouse.com) 


We’re excited to announce a new integration between ClickHouse and Microsoft OneLake, powered by the OneLake Tables APIs and Apache Iceberg.

large_onelake_image0.png

medium_onelake_image0.png

small_onelake_image0.png

thumbnail_onelake_image0.png

onelake_image0.png

ClickHouse integrates with Microsoft OneLake Table APIs

Can open table formats like Iceberg and Delta Lake really power observability at scale, and if not, what is missing today and which innovations could unlock low cost open observability?

large_lakehouses-o11y.png

medium_lakehouses-o11y.png

small_lakehouses-o11y.png

thumbnail_lakehouses-o11y.png

lakehouses-o11y.png

Are open-table-formats + lakehouses the future of observability?

Read how ClickHouse integrates with Apache Iceberg and other open table formats, enabling seamless querying, data ingestion, and federation across modern data architectures, with a roadmap for enhanced performance and deeper catalog integrations.

Melvyn Peignon

Blog posts by Melvyn Peignon

ClickHouse strengthens collaboration with Microsoft through Microsoft OneLake Integration for Seamless Data Interoperability

ClickHouse integrates with Microsoft OneLake Table APIs

Are open-table-formats + lakehouses the future of observability?

Climbing the Iceberg with ClickHouse