Loading…
Topic
Microsoft Fabric
3 posts about Microsoft Fabric. Every summary links to the original.
- 3 posts
- 1 company
The Good Stuff
Paid picks we use ourselves. Links carry a referral code — a subscription through one earns us a commission at no extra cost to you.
Newest first
Posts
ClickHouse expands collaboration with Microsoft, bringing Fabric integration, deeper OneLake interoperability, and enterprise deployment flexibility
ClickHouse announced a significant expansion of its strategic collaboration with Microsoft at The European Microsoft Fabric + SQL Community Conference, including the public preview of a native ClickHouse workload for Microsoft Fabric that brings sub-second analytical query latency to OneLake. The company also made generally available the ability to read Apache Iceberg tables from OneLake using OneLake Table APIs, and introduced a public preview of writing Iceberg tables back to OneLake. These capabilities eliminate data duplication and ingestion steps, allowing teams to keep OneLake as the governed single source of truth while leveraging ClickHouse’s speed. ClickHouse Bring Your Own Cloud (BYOC) is now available in the Microsoft Marketplace, enabling customers to run ClickHouse Cloud inside their own Azure tenant with full control over IAM, networking, and encryption. The integrations aim to serve real-time agentic workloads, interactive dashboards, and observability without separate cluster provisioning or ETL pipelines.
ClickHouse Workload for Microsoft Fabric: sub-second analytics on OneLake, now in public preview
The ClickHouse workload for Microsoft Fabric brings ClickHouse as a native acceleration layer for OneLake, now in public preview. It provisions dedicated ClickHouse Cloud services on Azure via the Fabric Extensibility Toolkit, using a ClickHouse item in the workspace. Users sync OneLake tables through ClickPipes as point-in-time snapshots with no ingestion charges. The embedded SQL console and external tools (Power BI, Copilot Studio, GitHub Copilot) can then query billions of rows with sub-second response times at high concurrency. Planned future features include write-back to OneLake, continuous sync, permission sync, and deeper Power BI integration.
ClickHouse now writes Apache Iceberg tables to Microsoft OneLake
ClickHouse previously wrote Iceberg tables to object storage without catalog registration, limiting their discoverability. Now it writes Iceberg tables directly to Microsoft OneLake, registering in the catalog via Iceberg REST Table APIs and securing with OneLake Security. Use cases include AI agents monitoring order data and publishing real-time anomaly detection results to OneLake, and applications writing directly via ClickHouse without a separate ingestion layer. The connection uses the DataLakeCatalog engine with catalog_type=‘onelake’, warehouse parameter combining workspace and lakehouse IDs, and Microsoft Entra ID service principal authentication; writing uses standard INSERT INTO syntax with backtick-quoted namespace.table names. OneLake automatically syncs Iceberg and Delta Lake formats, provides governance with lineage tracking and data protection, and its security APIs are opening to third-party engines; this is the first catalog to support writes from ClickHouse, with more catalogs planned.
Related topics
All topics →Weekly digest
The best engineering reads, once a week.