# Dremio and Microsoft Fabric: the published facts in the same rows

Side by side, read 10 Nov 2026

**The short answer.** Dremio (Lakehouse with its own SQL engine) and Microsoft Fabric (SaaS analytics on Azure with Spark) are set out here in the same rows: published speed and cost results, code changes, table upkeep, table formats and where each runs. On the Compute Bill's reference job: Dremio Cloud (Large engine): $102.40; Microsoft Fabric (F128 capacity): $46.08.

## The same rows for both

| Row | Dremio | Microsoft Fabric |
| --- | --- | --- |
| Kind | Lakehouse with its own SQL engine | SaaS analytics on Azure with Spark |
| Does well | Per Dremio documentation, Iceberg tables in the Open Catalog get automatic optimization: data file compaction, row-level delete handling, clustering, partition evolution and manifest rewriting (read 2026-11-10). Dremio publishes DCU rates by engine size, from 16 DCUs per hour for 2XSmall to 2048 for 3XLarge, with a 60-second minimum (read 2026-11-10). | Per Microsoft Learn, the native execution engine (Apache Gluten and Velox) needs no code changes, falls back to JVM Spark for unsupported operators and supports Parquet and Delta (read 2026-11-10). Per Microsoft Learn, OneLake S3 shortcuts give read-only access to data in an S3 bucket in any file format without copying it (read 2026-11-10). |
| Limited | Per Dremio documentation, queries run on its own columnar engine, not on Spark, and the pages read describe no mode that runs existing Spark jobs. Dremio Cloud documentation lists Iceberg and Delta Lake as table formats; Hudi support: none found on 2026-11-10. | Per Microsoft Learn, Fabric runs over OneLake on Azure and the region page lists Azure regions only, so Spark compute does not run inside AWS. Writes to S3 through a OneLake shortcut are not possible, and the method for Microsoft's native engine benchmark: none found on 2026-11-10. |
| Published speed results | Dremio's founder reported a full 1 TB TPC-DS run (all 99 queries) in 22 seconds on an 8-node m7gd.4xlarge cluster, with no caching, and attributes it to Autonomous Reflections and automatic Iceberg clustering. This is a BI query benchmark run by the vendor, not a Spark batch ETL or compaction test. | Microsoft reports that on TPC-DS scale factor 1000 with Delta the native engine was up to six times faster than open-source Spark, with about 83% compute cost savings on a fixed-size cluster. |
| Published prices and cost results | Dremio Cloud is priced at $0.20 per DCU (Dremio Compute Unit). Dremio Enterprise (self-managed) pricing is 'contact sales'. The free trial for Dremio Cloud is a $400 credit for 30 days. DCUs are consumed only while engines run. Usage equals engine and replica uptime in seconds (60-second minimum) times the DCU rate for the engine size. Published rates per hour: 2XSmall 16, XSmall 32, Small 64, Medium 128, Large 256, XLarge 512, 2XLarge 1024, 3XLarge 2048. Storage billed in TB-months only for Dremio-hosted storage; LLM tokens billed separately. Billable usage is DCUs (compute), LLM tokens (AI features) and storage. Compute is billed in DCUs only while engines are running. | The Azure retail price API lists Fabric Spark capacity usage at $0.18 per CU-hour for eastus (Spark Memory Optimized and autoscale for Spark entries, pay-as-you-go). In Fabric each capacity unit maps to two Spark VCores, and Spark jobs are admitted by available VCores with FIFO queueing and throttling. Autoscale Billing for Spark is an opt-in pay-as-you-go model that runs Spark on dedicated serverless resources at standard PAYG CU-hour rates; reserved capacity discounts do not apply and a base capacity is still required. |
| Code changes and migration | Dremio runs queries on its own columnar execution engine built on Apache Arrow, not on Spark. Docs describe Spark and Flink only as external engines that can use the Open Catalog (Iceberg REST) alongside Dremio. The pages read describe no mode that runs existing Spark jobs, so Spark ETL would stay on Spark or be rewritten as Dremio SQL. | The Fabric native execution engine, based on Apache Gluten and Velox, needs no code changes, falls back to JVM Spark for unsupported operators, and supports Parquet and Delta. |
| Tuning and table upkeep | For Iceberg tables in the Open Catalog, Dremio runs automatic optimization on a dedicated engine it configures: data file compaction, row-level delete handling (position deletes on v2, deletion vectors on v3), clustering, partition evolution and manifest rewriting. The same operations can be run by hand with OPTIMIZE TABLE. Optimization works in batches sized to engine resources. Engines have settings the admin chooses: size (executors per replica), min and max replicas, last-replica auto-stop (default 2 hours), enqueued time limit (default 5 minutes) and query runtime limit. Default concurrency per replica ranges from 2 (2XSmall) to 20 (3XLarge). | Starter pools start in 5 to 10 seconds with no setup; custom Spark pools let you tune node size and scaling, and native execution can be toggled per application with a Spark setting. |
| Spark versions and table formats | The Dremio Cloud data formats page lists Apache Iceberg and Delta Lake as table formats (plus Parquet and text formats). Hudi is not listed on that page. The Open Catalog is built on Apache Polaris and supports the Iceberg REST Catalog API; the docs list AWS Glue Data Catalog as a connectable catalog. | Fabric Runtime 1.3 uses Apache Spark 3.5 and Runtime 2.0 uses Spark 4.1; OneLake handles Delta and Iceberg through metadata virtualization so Iceberg tables read as Delta and vice versa. |
| Where it runs | Dremio Cloud runs on AWS (Azure listed as coming soon). Supported regions: us-east-1, us-east-2, us-west-2, eu-west-1 and eu-central-1. Dremio Enterprise can be deployed on Kubernetes, on premises, or in AWS, Azure or GCP. | Fabric workloads run over OneLake, described as built on Azure Data Lake Storage; the region availability page lists Azure regions and no AWS regions, so Spark compute does not run inside AWS. OneLake S3 shortcuts give read-only access to data in an S3 bucket in any file format without copying; file caching can reduce cross-cloud egress costs. Writes to S3 are not possible through the shortcut. |
| How open its benchmarks are | Dremio published a 2020 TPC-DS methodology post (SF1000 and SF10000, Parquet on S3, Apache JMeter test plans, 58 of 99 queries that ran unmodified on Dremio and Presto distributions). The 2025 22-second TPC-DS post pages read give cluster type but no scripts, scale-factor files or configuration repository. | None found on 10 Nov 2026. |
| Compute Bill | Dremio Cloud (Large engine): $102.40 | Microsoft Fabric (F128 capacity): $46.08 |

Alphabetical order. Vendor statements are the vendor's own. Read 10 Nov 2026.

## How to read this page

The rows hold what each vendor or a named third party published, with no conclusion drawn. Benchmarks in the two columns ran on different hardware, data and baselines, so their numbers are not comparable across columns. The [Compute Bill method](/compute-bill/method/) explains the cost lines.

## Sources

- Dremio: dremio.com/pricing: https://www.dremio.com/pricing (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/admin/engines: https://docs.dremio.com/dremio-cloud/admin/engines/ (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/admin/subscription/usage: https://docs.dremio.com/dremio-cloud/admin/subscription/usage (read 10 Nov 2026)
- Dremio: docs.dremio.com/current/what-is-dremio/architecture: https://docs.dremio.com/current/what-is-dremio/architecture (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/developer/data-formats: https://docs.dremio.com/dremio-cloud/developer/data-formats/ (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/manage-govern/optimization: https://docs.dremio.com/dremio-cloud/manage-govern/optimization (read 10 Nov 2026)
- Dremio: docs.dremio.com/dremio-cloud/about/regions: https://docs.dremio.com/dremio-cloud/about/regions (read 10 Nov 2026)
- Dremio: dremio.com/blog/breakthrough-announcement-dremio-is-the: https://www.dremio.com/blog/breakthrough-announcement-dremio-is-the-fastest-lakehouse-20x-faster-on-tpc-ds/ (read 10 Nov 2026)
- Dremio: dremio.com/blog/dremio-benchmarking-methodology: https://www.dremio.com/blog/dremio-benchmarking-methodology/ (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview: https://learn.microsoft.com/en-us/fabric/fundamentals/microsoft-fabric-overview (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/onelake/create-s3-shortcut: https://learn.microsoft.com/en-us/fabric/onelake/create-s3-shortcut (read 10 Nov 2026)
- Microsoft Fabric: prices.azure.com/api/retail/prices?$filter=serviceName%20eq%20'Microsoft: https://prices.azure.com/api/retail/prices?$filter=serviceName%20eq%20'Microsoft%20Fabric'%20and%20armRegionName%20eq%20'eastus'%20and%20priceType%20eq%20'Consumption' (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-job-concurrency-and-queueing (read 10 Nov 2026)
- Microsoft Fabric: azure.microsoft.com/en-us/pricing/details/microsoft-fabric: https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/ (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/runtime: https://learn.microsoft.com/en-us/fabric/data-engineering/runtime (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/onelake/onelake-iceberg-tables: https://learn.microsoft.com/en-us/fabric/onelake/onelake-iceberg-tables (read 10 Nov 2026)
- Microsoft Fabric: learn.microsoft.com/en-us/fabric/data-engineering/spark-compute: https://learn.microsoft.com/en-us/fabric/data-engineering/spark-compute (read 10 Nov 2026)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/compare/dremio-vs-microsoft-fabric/
