Dremiovs
Trino
Trino: If you want a free federated SQL engine and are willing to operate it and build acceleration yourself
Dremio
SQL query engine and lakehouse layer over Iceberg tables in object storage
As of 31 August 2026, Dremio has a free plan and paid plans start at $0.2/hour. A query engine that puts SQL and a semantic layer directly on Parquet and Apache Iceberg data in S3, so you can report without loading into a warehouse. Softwr lists it under Databases. Dremio is made by Dremio Corporation, available on Linux, Kubernetes, Cloud, Docker.
Overview
What Dremio does
Dremio is a lakehouse platform combining an Apache Arrow-based SQL execution engine, an Iceberg catalogue, and a semantic layer of virtual datasets. It queries Parquet, Iceberg and Delta files in object storage directly, and can federate to relational databases, presenting everything through one SQL interface to BI tools. Dremio Cloud runs it as a service billed per Dremio Compute Unit; Dremio Enterprise runs the same engine on your own Kubernetes or servers. The distinguishing mechanism is Reflections: materialised, incrementally maintained derivatives of a dataset that the optimiser substitutes into queries transparently. A dashboard hitting a slow lake table gets warehouse-like response times without anyone rewriting the query or building an aggregate table by hand. Commercially this is how Dremio argues against loading everything into Snowflake, since the data stays in your bucket in an open format you can also read with Spark, Trino or anything else that speaks Iceberg. Buyers are enterprises with large volumes already in object storage who object to warehouse storage markups or to vendor lock-in on table format. The trade-off is operational: Reflections consume compute and storage to build and refresh, and a team that turns them on liberally can find that background refresh, not user queries, dominates the bill. Self-managed Dremio on Kubernetes is a genuine platform engineering commitment, not an install.
What people use it for
- A company with petabytes of Parquet in S3 that wants BI dashboards without duplicating it into a warehouse
- A data platform team standardising on Apache Iceberg and needing a SQL engine plus catalogue that does not lock the tables in
- An analytics group accelerating slow lake queries with Reflections instead of hand-built aggregate tables
- A regulated enterprise that must keep data on premises but wants a modern lakehouse SQL layer
Related searches
The honest half
Where it falls short
Concrete and checkable, so you can decide whether any of them matter to you. This is the half of a review a vendor will not write about Dremio.
- Reflections consume compute and storage to build and refresh continuously, so a team that enables them widely discovers that background maintenance rather than user queries drives the DCU bill.
- Self-managing Dremio on Kubernetes requires real platform engineering capacity for tuning executors, memory and coordinator sizing, and it is not comparable in effort to running a managed warehouse.
- The Community Edition lacks the security and governance features most enterprises require, so the free tier is a trial path rather than a viable production option for regulated buyers.
- Dremio Cloud is AWS-first, which leaves Azure and Google Cloud customers on the self-managed path with the operational burden that entails.
- Query performance without Reflections on raw, poorly laid out files is often unremarkable, so the promise of querying the lake as is depends on file layout work you still have to do.
Cross-shopped
What people choose instead of Dremio
Each pairing was judged by two reviewers asking whether a buyer would genuinely weigh the two against each other. The ones that failed were deleted rather than published.
- DremiovsDatabricks
Databricks: If you want lakehouse plus data science and ML on one platform and accept a heavier commercial footprint
- DremiovsSnowflake
Snowflake: If you would rather load the data and pay for a fully managed warehouse than manage lake file layout
Pricing
What Dremio costs
Taken from the vendor's own pricing page. Prices move, so check before you buy.
Community Edition
Free
- Self-managed on your own hardware
- SQL engine and semantic layer
- No vendor support
- Missing enterprise security and governance features
Dremio Cloud
$0.2 /hour
- Billed at $0.20 per Dremio Compute Unit
- Includes query execution, Reflections and background processing
- 400 dollar trial credit for 30 days
- Managed on AWS
Enterprise
On request
- Self-managed on Kubernetes, on premises or any cloud
- Enterprise security, SSO and governance
- Vendor support with SLA
- Priced by negotiation
Capabilities
Features
Arrow-based execution
Columnar in-memory engine with vectorised query processing
Reflections
Automatically substituted materialisations that accelerate queries transparently
Semantic layer
Virtual datasets, spaces and column-level lineage over physical files
Iceberg catalogue
Integrated catalogue with Git-style branching for table versions
Federated queries
Joins across object storage, Postgres, Elasticsearch and other sources
Autonomous management
Automatic Iceberg compaction and vacuum for table maintenance
Fine-grained access control
Row and column policies enforced at the engine
BI connectors
Arrow Flight, JDBC and ODBC for Tableau, Power BI and others
Answered, with sources
Questions people ask
Each answer names the page it came from, so you can check it rather than take our word for it.
How is Dremio Cloud billed?
At 0.20 US dollars per Dremio Compute Unit, which counts query execution, Reflection building and platform overhead, not just user queries.
Is there a free version?
Yes, a Community Edition you self-manage, but it omits the enterprise security and governance features and comes with no support.
Does it lock in my data?
No, tables stay in Apache Iceberg or Parquet in your own object storage and can be read by Spark, Trino or other engines.
Do I still need a warehouse?
Often not for analytics, but Dremio is not a transactional store and high-concurrency operational serving is not its strength.
Keep looking
Where to go from Dremio
- Dremio alternativesEvery product people weigh against it
- Dremio pricingPlans, floors and what the tiers exclude
- Dremio badgesWhich rules it meets, and the figure behind each
- All Databases softwareThe full category
- Best Databases softwareThe shortlist, and how it was cut
Best Databases software for
Compare Dremio with
- Presto
- StarRocks
- DuckDB
- BigQuery
- turbopuffer
- Amazon Redshift
- Knack
- LanceDB
- Meilisearch
- Turso
- Firebolt
- MotherDuck
- Privacera
- RavenDB
- Readyset
- Redpanda
- RisingWave
- Presto
Other Databases software
The Meta-lineage distributed SQL query engine, distinct from the Trino fork
Open source12 researched notesApache 2.0 MPP analytical database built for joins on open table formats
Open source12 researched notesMIT-licensed analytical SQL database that runs inside your process, with no server, no dependencies and one writer at a time.
Free plan14 researched notesGoogle Cloud's serverless analytical warehouse, billed either by bytes scanned per query or by reserved compute slots.
Free plan13 researched notesClosed-source vector and full-text search service built directly on object storage, with cold queries measured in seconds rather than milliseconds.
From $16/mo14 researched notesHosted no-code database and web app builder priced by stored records and storage, with unlimited user accounts on every plan.
From $59/mo14 researched notesEmbedded retrieval library over the Apache 2.0 Lance columnar format, with proprietary Cloud and Enterprise tiers for serving at scale.
Pricing on request14 researched notesSQLite-lineage database platform for running very large numbers of small per-tenant databases, with an MIT-licensed engine.
Free, then $4.99/mo14 researched notesCentralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI
Pricing on request13 researched notesDatabase caching and optimization that reduces infrastructure costs 30-70%
Free plan10 researched notesStreaming database that maintains incremental materialised views in SQL instead of Flink jobs
Free, then $0.227/hour12 researched notesThe Meta-lineage distributed SQL query engine, distinct from the Trino fork
Open source12 researched notes
Softwr does not host reviews and shows no star rating for Dremio, because a rating we did not collect is not ours to publish. What is here is the pricing and platform detail from the vendor’s own pages, limitations we could state concretely, and alternatives a reviewer confirmed people weigh against it. Tell us if any of it is wrong.
More on Dremio
Dremio alternatives
What people switch to, and what they give up
Dremio pricing
Every tier, and where the cost actually lands
Compare Dremio
Put it head to head with anything we hold
Dremio badge
Its rating, and an embed for your own site
Best Databases software alternatives
Industrial process historian with published per-tag pricing and no client licence fees
Per tag band per year
NetApp-owned managed service for Cassandra, Kafka, OpenSearch, PostgreSQL and Cadence with a bring-your-own-cloud model
quote
Erlang MQTT broker for large IoT fleets, relicensed to BSL with production free use limited to one node
Per month by connection and session volume
Attribute-based access control and masking applied inside Snowflake, Databricks and BigQuery
quote
MPP analytical database with a MySQL wire protocol and sub-second aggregation on wide tables
Open source, no licence feeStreaming database that maintains incremental materialised views in SQL instead of Flink jobs
Per RisingWave Unit hourCentralised data access governance from the creators of Apache Ranger, now rebranding as Trust3 AI
quoteThe Meta-lineage distributed SQL query engine, distinct from the Trino fork
Open source, no licence fee