--- title: ClickHouse Workload for Microsoft Fabric: sub-second... description: ClickHouse has launched a native workload for Microsoft Fabric, now in public preview, that provisions a dedicated ClickHouse Cloud service to accelerate... canonical: https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview | daily.dev og:description: ClickHouse has launched a native workload for Microsoft Fabric, now in public preview, that provisions a dedicated ClickHouse Cloud service to accelerate... og:url: https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji og:image: https://api.daily.dev/og/posts/CN5daBPJI.png og:image:alt: ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview **[ClickHouse](https://daily.dev/sources/clickhouse)** · 6 min read · 0 upvotes · 0 comments ## Summary ClickHouse has launched a native workload for Microsoft Fabric, now in public preview, that provisions a dedicated ClickHouse Cloud service to accelerate analytics on OneLake data. It syncs OneLake tables as accelerated copies without custom ETL pipelines, offers an embedded SQL console, and provides governed read-only access for AI agents (Copilot Studio, GitHub Copilot, MCP-compatible tools), Power BI, and Fabric notebooks. It runs on dedicated Azure compute so agent and dashboard workloads don't compete with Fabric capacity. Future plans include write-back to OneLake, continuous replication, permission sync, and full-text/vector search support. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How does the ClickHouse workload for Microsoft Fabric accelerate queries on OneLake data? It syncs selected OneLake tables into a dedicated ClickHouse Cloud service provisioned inside your Fabric workspace, using ClickPipes managed ingestion, so full-table aggregations over billions of rows return in milliseconds. OneLake remains the source of truth while ClickHouse acts as an acceleration layer, with an embedded SQL console and governed read-only access for AI agents, Power BI, and Fabric notebooks. _Track how ClickHouse and Fabric evolve their OneLake acceleration workflow on daily.dev._ ### Does the ClickHouse Fabric workload support continuous sync from OneLake or just one-time snapshots? In public preview, syncs from OneLake are point-in-time snapshots with no ingestion charges, not continuous replication. Continuous sync beyond snapshots, along with write-back to OneLake and permission sync, is listed as planned future work rather than something available now. _Developers evaluating OneLake sync limits can follow ClickHouse Fabric updates on daily.dev._ ### How can AI agents query ClickHouse data synced from Microsoft Fabric's OneLake? Turning on agent access makes the dedicated ClickHouse Cloud service a governed, read-only endpoint reachable by Microsoft Copilot Studio, Microsoft Foundry, GitHub Copilot, and any MCP-compatible tool. This runs on dedicated compute billed through the Microsoft Marketplace, so agent and application queries never compete with existing Power BI capacity. _Anyone wiring agents into Fabric data can keep up with ClickHouse integration news on daily.dev._ ## Similar posts on daily.dev - [ClickHouse expands collaboration with Microsoft, bringing Fabric integration, deeper OneLake interoperability, and enterprise deployment flexibility](https://daily.dev/posts/clickhouse-expands-collaboration-with-microsoft-bringing-fabric-integration-deeper-onelake-interop-bifbf9a3m) · ClickHouse · 0 upvotes · 0 comments - [ClickHouse now writes Apache Iceberg tables to Microsoft OneLake](https://daily.dev/posts/clickhouse-now-writes-apache-iceberg-tables-to-microsoft-onelake-rt8ey7vct) · ClickHouse · 1 upvotes · 0 comments --- Tags: [#data-analysis](https://daily.dev/tags/data-analysis), [#clickhouse](https://daily.dev/tags/clickhouse), [#power-bi](https://daily.dev/tags/power-bi), [#microsoft-fabric](https://daily.dev/tags/microsoft-fabric) [View this post on daily.dev](https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview","url":"https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji"},"datePublished":"2026-09-29T07:21:49.628Z","dateModified":"2026-10-06T19:19:08.807Z","description":"ClickHouse has launched a native workload for Microsoft Fabric, now in public preview, that provisions a dedicated ClickHouse Cloud service to accelerate...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/4a479310cf235a97a0cb77b353c1af15?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/4a479310cf235a97a0cb77b353c1af15?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"data-analysis,clickhouse,power-bi,microsoft-fabric","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/clickhouse-workload-for-microsoft-fabric-sub-second-analytics-on-onelake-now-in-public-preview-cn5dabpji#faq","mainEntity":[{"@type":"Question","name":"How does the ClickHouse workload for Microsoft Fabric accelerate queries on OneLake data?","acceptedAnswer":{"@type":"Answer","text":"It syncs selected OneLake tables into a dedicated ClickHouse Cloud service provisioned inside your Fabric workspace, using ClickPipes managed ingestion, so full-table aggregations over billions of rows return in milliseconds. OneLake remains the source of truth while ClickHouse acts as an acceleration layer, with an embedded SQL console and governed read-only access for AI agents, Power BI, and Fabric notebooks. Track how ClickHouse and Fabric evolve their OneLake acceleration workflow on daily.dev."}},{"@type":"Question","name":"Does the ClickHouse Fabric workload support continuous sync from OneLake or just one-time snapshots?","acceptedAnswer":{"@type":"Answer","text":"In public preview, syncs from OneLake are point-in-time snapshots with no ingestion charges, not continuous replication. Continuous sync beyond snapshots, along with write-back to OneLake and permission sync, is listed as planned future work rather than something available now. Developers evaluating OneLake sync limits can follow ClickHouse Fabric updates on daily.dev."}},{"@type":"Question","name":"How can AI agents query ClickHouse data synced from Microsoft Fabric's OneLake?","acceptedAnswer":{"@type":"Answer","text":"Turning on agent access makes the dedicated ClickHouse Cloud service a governed, read-only endpoint reachable by Microsoft Copilot Studio, Microsoft Foundry, GitHub Copilot, and any MCP-compatible tool. This runs on dedicated compute billed through the Microsoft Marketplace, so agent and application queries never compete with existing Power BI capacity. Anyone wiring agents into Fabric data can keep up with ClickHouse integration news on daily.dev."}}]} ```