...

ClickHouse Microsoft Collaboration Grows With Fabric Integration, OneLake Interoperability, and Flexible Enterprise Deployment

ClickHouse Microsoft collaboration

ClickHouse announced a major expansion of its ClickHouse Microsoft collaboration today. The company builds the open-source, real-time analytical database that has become the data layer for the AI era. It made the announcement at The European Microsoft Fabric + SQL Community Conference. The expansion includes four major milestones. First, ClickHouse launched its native workload for Microsoft Fabric. Second, OneLake read is now generally available. Third, OneLake write has entered public preview. Finally, ClickHouse Bring Your Own Cloud (BYOC) is now available in the Microsoft Marketplace.

This ClickHouse Microsoft collaboration move builds on ClickHouse’s growing presence in the Microsoft ecosystem. Data-intensive organizations already rely on ClickHouse Cloud on Azure. They use it to power real-time observability, business intelligence, AI/ML pipelines, and analytical applications at scale. Moreover, the deeper collaboration reflects a shared commitment from both companies. Together, they want to give data teams fast, flexible, and open infrastructure for the next generation of analytics and AI.

“Expanding our collaboration with Microsoft brings ClickHouse performance and deployment flexibility to where our customers’ data increasingly lives,” said Yury Izrailevsky, President, Product & Engineering at ClickHouse. “Our engineering teams have worked closely together so that these capabilities are seamlessly integrated into the Microsoft data platform rather than layered on top of it, and joint customers no longer have to trade off between the platforms they’ve standardized on.”

Sub-Second Analytics With the ClickHouse Workload for Microsoft Fabric

The ClickHouse workload for Microsoft Fabric is now in public preview. Users can find it through the Fabric workload hub. It brings the ClickHouse query engine directly into the Fabric experience. As a result, data teams can speed up OneLake queries to sub-second response times without leaving Fabric.

For joint customers, the value is simple. Fabric provides the unified data estate, the governance, and the business user surface area. ClickHouse, in turn, provides the speed. Highly concurrent agentic workloads, real-time interactive dashboards, and observability were previously impractical to serve directly from a lakehouse. Now, however, they run at the latency users expect. Teams need no separate cluster to provision. Likewise, they have no ETL pipeline to maintain.

“We’ve long believed that unifying data in OneLake using open, standards-based formats will enable customers to innovate faster,” said Dipti Borkar, Vice President, Microsoft IQ and OneLake, Microsoft. “With the ClickHouse workload available in Fabric, running on OneLake, joint customers have more best-in-class analytical engines to choose from to deliver analytics and AI, without moving or copying data between platforms. This collaboration is a strong example of our partner ecosystem extending what teams can do on a single, unified data estate.”

Apache Iceberg Read and Write Support for OneLake

ClickHouse Microsoft collaboration support for reading Apache Iceberg tables from OneLake is now generally available. It works through the OneLake Table APIs. Customers can query Iceberg tables managed in OneLake directly from ClickHouse. They need no data duplication and no ingestion step. Therefore, the update removes a long-standing friction point. Data teams historically had to choose between a governed lakehouse and a fast analytical engine. Now, organizations can keep OneLake as the single source of truth. At the same time, they can apply the ClickHouse query engine across the full breadth of their data.

In addition, ClickHouse support for writing Iceberg tables to OneLake is now in public preview. It also uses the OneLake Table APIs with credential vending. ClickHouse users can write results back into OneLake as governed, open-format tables. Any Fabric engine can read those tables. Consequently, the data lifecycle comes full circle. Teams can read data from OneLake and transform and aggregate it at ClickHouse speed. Then they can write it back into the lakehouse. Power BI, notebooks, and the rest of the Fabric ecosystem consume it there.

ClickHouse BYOC Now Available in the Microsoft Marketplace

ClickHouse Bring Your Own Cloud (BYOC) is now available to Azure customers through the Microsoft Marketplace. BYOC lets organizations run ClickHouse Cloud inside their own Azure tenant. As a result, they get the operational simplicity of a fully managed service. Meanwhile, they keep control of their data environment. Data never leaves the customer’s environment. IAM policies, network controls, and encryption configuration stay under the customer’s direct ownership. ClickHouse, on the other hand, manages provisioning, upgrades, monitoring, and scaling.

Enterprises often operate under strict data residency, compliance, or sovereignty requirements. For them, BYOC offers a path to adopt ClickHouse Cloud without compromise. Furthermore, Microsoft Marketplace availability means customers can buy both products through existing Microsoft agreements. Both products also count toward Microsoft Azure Consumption Commitments (MACC). Thus, enterprise buyers face less procurement friction.

Explore IT Tech News for the latest advancements in Information Technology & insightful updates from industry experts!

News Source: Businesswire.com