ClickHouse Deepens Collaboration with Microsoft through OneLake Integration for Real-Time Analytics
ClickHouse Inc., the company behind one of the world’s fastest and most widely adopted real-time analytics databases, has announced a transformative integration with Microsoft OneLake, the unified data lake within Microsoft Fabric. This collaboration empowers organizations to combine the scalability, governance, and simplicity of OneLake with the unmatched speed and flexibility of ClickHouse for large-scale, real-time analytical workloads. This milestone underscores ClickHouse’s ongoing commitment to delivering seamless interoperability across Microsoft’s data ecosystem, enabling businesses to unlock the full potential of their data.
Strengthening the ClickHouse-Microsoft Partnership
This integration builds on ClickHouse’s expanding collaboration with Microsoft, which includes the general availability of ClickHouse Cloud on Microsoft Azure, recent performance enhancements for ClickHouse on Azure Blob Storage, and a steady stream of new capabilities tailored for Microsoft customers. The partnership reflects ClickHouse’s dedication to providing robust, real-time analytics solutions that integrate seamlessly into Microsoft’s platforms, from Azure to Fabric.
By bridging ClickHouse’s high-performance analytics capabilities with Microsoft’s comprehensive data infrastructure, this initiative enables organizations to perform real-time analytics within a unified platform. The result is a streamlined experience that allows users to leverage the best tools for their specific workloads while maintaining seamless interoperability.
Enhancing Interoperability with Microsoft OneLake
As organizations increasingly adopt lakehouse architectures—a flexible foundation that supports best-of-breed tools across diverse workloads—the need for interoperability has never been greater. Lakehouse architectures enable teams to store data in open table formats like Apache Iceberg or Delta Lake, ensuring accessibility and compatibility across various analytics engines, including ClickHouse.
The new ClickHouse integration with OneLake Table APIs takes this interoperability to the next level by exposing Iceberg tables directly to ClickHouse. This functionality allows users to query and analyze their data stored in OneLake without friction, facilitating federated and unified analytics across both ClickHouse and Microsoft Fabric. By removing barriers to data movement and analysis, this integration ensures that teams can always use the right tool for the job, whether it’s real-time analytics, AI-driven insights, or operational reporting.
Enabling Real-Time Analytics with ClickHouse
One of the most significant challenges in modern data analytics is simplifying data ingestion and ensuring low-latency access to critical information. With this integration, Fabric customers gain powerful new options to query their OneLake data using ClickHouse, enabling real-time analytics at scale. This capability opens the door to a wide range of high-impact use cases, including:
- Real-time observability: Monitor systems and applications with up-to-the-second insights.
- Operational dashboards: Deliver dynamic, interactive visualizations for decision-makers.
- Agent-facing analytics: Power AI agents and applications with real-time data queries.
- Cybersecurity and fraud detection: Identify and respond to threats in real time.
“Microsoft OneLake is an incredibly popular data lake solution among our users, and we’ve long wanted to provide a direct integration to enhance their experience,” said Alexey Milovidov, Co-Founder and CTO of ClickHouse. “With the introduction of Table APIs in OneLake, we were finally able to make this vision a reality. ClickHouse can now natively query data stored in OneLake, giving users seamless access to all their data with zero friction.”
Driving Data Interoperability Across Ecosystems
The ability to integrate diverse tools and platforms is essential for maximizing the value of data. As Dipti Borkar, VP & GM for Microsoft OneLake and Fabric Ecosystem, explained, “For data to be useful, it must be interoperable with a range of tools our customers use every day. With this integration, customers can now use ClickHouse on data unified by Microsoft OneLake to address some of the most data-intensive use cases, such as real-time observability, cybersecurity, fraud detection, and AI.”
This collaboration not only enhances the capabilities of both platforms but also reinforces the importance of open standards and interoperability in modern data architectures. By supporting open table formats like Apache Iceberg, ClickHouse and Microsoft are empowering organizations to build flexible, future-proof data ecosystems that can adapt to evolving business needs.
Simplifying Data Movement and Analysis
A key advantage of this integration is its ability to simplify data movement and analysis. Traditionally, transferring data between systems has been a complex and time-consuming process, often requiring custom scripts or middleware. With ClickHouse’s native support for OneLake, users can bypass these hurdles and access their data directly, reducing latency and improving efficiency.
For example, businesses can now ingest data into OneLake and immediately begin analyzing it with ClickHouse, eliminating delays and enabling faster decision-making. This seamless workflow is particularly valuable for industries that rely on real-time insights, such as finance, healthcare, and e-commerce.
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.
