ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview

On September 29 2026 ClickHouse announced that its analytical database is now offered as a public‑preview workload inside Microsoft Fabric. The new workload lets users synchronize OneLake tables to a dedicated ClickHouse Cloud service with just a few clicks, and then run sub‑second queries on billions of rows from within the Fabric workspace. The integration is presented as a native acceleration layer that consumes no Fabric capacity and is billed through the Microsoft Marketplace. The capability addresses a growing need for millisecond‑level responses when AI agents, dashboards, or customer‑facing applications query governed data stored in OneLake. By offloading heavy analytical work to ClickHouse Cloud, teams can avoid building custom caching layers or external ETL pipelines, simplifying architecture and reducing operational overhead. The service also provides read‑only, governed access for tools such as Copilot Studio and Power BI, expanding the range of analytics scenarios that can run at high concurrency without impacting existing Fabric workloads. It remains unclear how write‑back from ClickHouse to OneLake will function, as the feature is only mentioned as a future plan. The extent of permission synchronization between Fabric and ClickHouse has not been detailed, and deeper Power BI integration is still under development. These uncertainties are based on statements from the ClickHouse team about upcoming work.