# Dremio, Lakehouse with its own SQL engine: the published facts

Platform profile, read 10 Nov 2026

**The short answer.** Dremio Cloud runs SQL on its own Arrow-based engine and manages Iceberg tables in a built-in Open Catalog based on Apache Polaris. It bills $0.20 per Dremio Compute Unit, only while engines run. SAP announced on July 6, 2026 that it completed its acquisition of Dremio.

- **Kind:** Lakehouse with its own SQL engine
- **Website:** [www.dremio.com](https://www.dremio.com/)
- **Name checked:** Still sold as Dremio. SAP agreed to acquire Dremio on May 4, 2026 and completed the acquisition on July 6, 2026. The Dremio website now carries the banner 'Dremio is now part of SAP'.
- **Read:** 10 Nov 2026

## What it 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).

## Where it is 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.

## Published speed results

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor | [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/), 10 Nov 2026 |

## Published prices and cost results

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor | [dremio.com/pricing](https://www.dremio.com/pricing), 10 Nov 2026 |
| 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. | vendor docs | [docs.dremio.com/dremio-cloud/admin/engines](https://docs.dremio.com/dremio-cloud/admin/engines/), 10 Nov 2026 |
| Billable usage is DCUs (compute), LLM tokens (AI features) and storage. Compute is billed in DCUs only while engines are running. | vendor docs | [docs.dremio.com/dremio-cloud/admin/subscription/usage](https://docs.dremio.com/dremio-cloud/admin/subscription/usage), 10 Nov 2026 |

## Code changes and migration

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor docs | [docs.dremio.com/current/what-is-dremio/architecture](https://docs.dremio.com/current/what-is-dremio/architecture), 10 Nov 2026 |

## Tuning and table upkeep

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor docs | [docs.dremio.com/dremio-cloud/manage-govern/optimization](https://docs.dremio.com/dremio-cloud/manage-govern/optimization), 10 Nov 2026 |
| 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). | vendor docs | [docs.dremio.com/dremio-cloud/admin/engines](https://docs.dremio.com/dremio-cloud/admin/engines/), 10 Nov 2026 |

## Spark versions and table formats

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor docs | [docs.dremio.com/dremio-cloud/developer/data-formats](https://docs.dremio.com/dremio-cloud/developer/data-formats/), 10 Nov 2026 |

## Where it runs

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor docs | [docs.dremio.com/dremio-cloud/about/regions](https://docs.dremio.com/dremio-cloud/about/regions), 10 Nov 2026 |

## How open its benchmarks are

| Fact | Source type | Source, read |
| --- | --- | --- |
| 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. | vendor | [dremio.com/blog/dremio-benchmarking-methodology](https://www.dremio.com/blog/dremio-benchmarking-methodology/), 10 Nov 2026 |

## Profile

| Fact | Source type | Source, read |
| --- | --- | --- |
| SAP and Dremio announced on May 4, 2026 that SAP agreed to acquire Dremio. Terms were not disclosed and the deal was pending regulatory approval at announcement. SAP said Business Data Cloud will become an Apache Iceberg-native lakehouse using Dremio. | vendor | [news.sap.com/2026/05/sap-to-acquire-dremio](https://news.sap.com/2026/05/sap-to-acquire-dremio/), 10 Nov 2026 |
| SAP announced on July 6, 2026 that it completed the acquisition of Dremio. | vendor | [news.sap.com/2026/07/sap-completes-dremio-acquisition](https://news.sap.com/2026/07/sap-completes-dremio-acquisition/), 10 Nov 2026 |
| The dremio-oss GitHub repository is licensed Apache-2.0 and its last push was 2025-09-26, so the open-source repository has been quiet while the commercial products (Dremio Cloud, Dremio Enterprise, Dremio Community Edition) continue. | open source project | [api.github.com/repos/dremio/dremio-oss](https://api.github.com/repos/dremio/dremio-oss), 10 Nov 2026 |

## On the Compute Bill

| Line | How it is billed | Formula | Stated cost | What is in and out |
| --- | --- | --- | --- | --- |
| [Dremio Cloud (Large engine)](/platforms/dremio/) | DCUs consumed per hour by engine size while the engine runs, times a price per DCU. | Large engine = 256 DCUs per hour. 256 x 2 hours = 512 DCUs x $0.20 = $102.40. | $102.40 | Includes engine DCUs for two hours of one Large replica. Excludes storage, LLM token charges and data transfer. The engines page lists executors per size but not the vCPU or memory of an executor, so which size equals the reference workload is an assumption. An XLarge engine (16 executors, 512 DCUs per hour) would give $204.80. Dremio Cloud runs SQL in its own engine, not Spark on EC2. The Dremio pricing page returned an access error to the fetch tool on 2026-11-10 and the $0.20 rate was read through a second fetch method. |

## Searched for and none found on 10 Nov 2026

- Published cost for the same Spark batch work (ETL, joins, compaction) on Dremio versus Spark (searched: dremio.com/pricing, docs.dremio.com/dremio-cloud/admin/subscription/usage, dremio.com/post-sitemap.xml)
- Apache Hudi table support in Dremio Cloud docs (searched: docs.dremio.com/dremio-cloud/developer/data-formats, docs.dremio.com/llms.txt)
- Independent third-party Dremio benchmark (searched: dremio.com/post-sitemap.xml, news.google.com/rss/search?q=Dremio+acquires+OR+acquired+OR+funding)

## Dremio side by side with each other entry

- [Dremio and Amazon EMR plus Athena on Iceberg](/compare/aws-emr-athena-iceberg-vs-dremio/)
- [Dremio and Databricks](/compare/databricks-vs-dremio/)
- [Dremio and DualBird](/compare/dremio-vs-dualbird/)
- [Dremio and Google BigQuery and BigLake](/compare/bigquery-biglake-vs-dremio/)
- [Dremio and Microsoft Fabric](/compare/dremio-vs-microsoft-fabric/)
- [Dremio and Onehouse](/compare/dremio-vs-onehouse/)
- [Dremio and Open stack on EMR and EKS](/compare/dremio-vs-open-stack-emr-eks/)
- [Dremio and Snowflake](/compare/dremio-vs-snowflake/)
- [Dremio and Starburst](/compare/dremio-vs-starburst/)

## Sources

- Dremio: news.sap.com/2026/05/sap-to-acquire-dremio: https://news.sap.com/2026/05/sap-to-acquire-dremio/ (read 10 Nov 2026)
- Dremio: news.sap.com/2026/07/sap-completes-dremio-acquisition: https://news.sap.com/2026/07/sap-completes-dremio-acquisition/ (read 10 Nov 2026)
- Dremio: api.github.com/repos/dremio/dremio-oss: https://api.github.com/repos/dremio/dremio-oss (read 10 Nov 2026)
- 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)

Last reviewed 10 Nov 2026. Canonical: https://datalakehousecompare.com/platforms/dremio/
