Dremio
Dremio: A flexible lakehouse for querying diverse data estates across cloud and self-hosted environments. Ranked #2 of 23 in Data Lakehouse Platforms by our editors (9.1/10); pricing: Free plan · 30-day trial; best for federated SQL across diverse data estates.
At a glance
- Editor score9.1 / 10
- PricingFree plan · 30-day trial
- Best forFederated SQL across diverse data estates
- Free planYes
- Storage modelBoth
- Founded2015 · Austin, Texas, United States
- Facts checked20 Sep 2026
Where it wins
- Federated queries across databases, warehouses, object storage, and NoSQL
- Native Apache Iceberg support with Polaris-powered Open Catalog
- Cloud, self-managed, Kubernetes, on-premises, and API deployment options
Where it doesn't
- Enterprise pricing requires contacting sales
- Cloud usage is consumption-based and measured in DCUs
- Customer cloud infrastructure costs may still apply on the free tier
Our verdict on Dremio
Dremio is an open data lakehouse platform for organizations that need governed analytics across object storage, databases, and lakehouse catalogs. Its distributed SQL engine supports federated queries across databases, warehouses, object storage, and NoSQL sources. The product also covers data engineering and AI workloads through Apache Iceberg, Delta Lake, streaming ingestion with CREATE PIPE, and integrations with engines and tools such as Apache Spark, Apache Flink, Trino, Tableau, Power BI, dbt, Looker, Excel, and Jupyter. Deployment spans managed cloud, self-managed environments, and local machines or servers.
The plan structure suits teams that want to start with a free option and expand into managed or enterprise deployment. Standard is a forever-free cloud tier with up to three projects, SQL support, and Apache Iceberg and Delta Lake support. Dremio Cloud adds a fully managed cloud lakehouse, automatic scaling and optimization, consumption-based pricing, and a 30-day trial. Dremio Enterprise is self-managed and runs on Kubernetes, on-premises, or in the cloud, adding advanced security and governance plus enterprise support. The free tier can still involve customer cloud infrastructure costs, while enterprise pricing is contact-sales.
Dremio’s strongest fit is a data estate that spans multiple systems and needs one SQL layer with governance and catalog flexibility. Role-based access control, row filters, column masking, Reflections, Iceberg table clustering, and automatic maintenance support both access control and query performance. Its Open Catalog is powered by Apache Polaris, and the platform connects with AWS Glue Data Catalog, Snowflake Open Catalog, and Unity Catalog. Choose Dremio for broad federation and open table-format support; teams seeking only a narrow single-source analytics tool may find this scope unnecessary.
Your product? Our editors can test Dremio in depth and publish a review, labelled as paid · from $149/mo →
Dremio pricing
All 3 Dremio plans and prices →
Dremio fact sheet
| Free plan | Yes |
|---|---|
| Paid from | Not verified |
| Storage model | Both |
| SQL analytics | Yes |
| ACID transactions | Yes |
| Table format support | Open |
| Streaming ingestion | Yes |
| Governance catalog | Yes |
| Free trial | 30 days · no card needed |
| Deployment | Cloud, Self-hosted |
| Platforms | Web |
| Compliance & security | SOC 2, ISO 27001, GDPR |
| Support | Email, Tickets, Community, Docs · 24/7 |
| Built for | Mid-market, Enterprise (editorial estimate) |
| Integrations | 15 integrations: Amazon S3, Azure Storage, AWS Glue Data Catalog, Snowflake Open Catalog, Unity Catalog, Apache Spark … See all → |
| Pricing | Free plan · 30-day trial (source) |
| Website | dremio.com |
| Facts checked | 20 Sep 2026 |
Dremio integrations
Dremio lists 15 integrations on its own site.
- Amazon S3
- Azure Storage
- AWS Glue Data Catalog
- Snowflake Open Catalog
- Unity Catalog
- Apache Spark
- Apache Flink
- Trino
- DuckDB
- Tableau
- Power BI
- dbt
- Looker
- Microsoft Excel
- Jupyter
Alternatives to Dremio
- Databricks Data Intelligence PlatformA broad lakehouse platform for engineering, analytics, streaming, machine learning, and AI.9.4
- Starburst Data PlatformA broad Trino-based lakehouse for federated SQL, ingestion, and governed analytics.8.9
- Starburst GalaxyA managed Trino-based lakehouse platform for federated SQL and governed analytics.8.8
Dremio vs the competition
- Dremio vs Databricks Data Intelligence Platform
- Dremio vs Starburst Data Platform
- Dremio vs Starburst Galaxy
- Dremio vs Apache Hudi
- Dremio vs Google Cloud Lakehouse for Apache Iceberg
- Dremio vs Cloudera Open Data Lakehouse
Compare Dremio with any tool side by side →
Also Ranked In
Dremio is ranked in 9 of our directories; the 6 strongest besides Data Lakehouse Platforms.
Used Dremio? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Dremio for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Dremio is listed in our Data Lakehouse Platforms directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/dremio/"><img src="https://www.itechguides.com/best/badge/dremio.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update