SQL Query Engine

Get Started for Free

The Lakehouse Query Engine optimized for high performance and efficiency on Apache Iceberg and all your data

The #1 SQL Query Engine for Apache Iceberg

Designed from the ground up to be the fastest, most performant, and powerful SQL Query Engine for Apache Iceberg, Dremio delivers superior query performance and optimized price performance across all your data. Real-time memory management that dynamically manages memory and optimizes allocation reduces memory usage, heightens performance, scalability, and stability, and ensures successful analytical query operations even with vast datasets.

iceberg catalogue with logos

Optimized price performance for every query

Execute every query with the optimal balance of speed and cost-effectiveness. Dremio's multi-engine architecture enables sophisticated workload management. It's simple to create multiple right-sized, physically isolated engines for various workloads in your organization, ensuring performance predictability and making it easy to manage critical SLAs. Intelligent autoscaling dynamically manages your query workload based on established engine parameters.

Cost-based optimization ensures the fastest path to complete every query by understanding deep data statistics, including location, cardinality, and distribution.

Up to 100x faster performance with Reflections query acceleration

Attain near-instantaneous query performance with Reflections query acceleration. Reflections are optimized relational caches that use algebraic matching to accelerate entire or partial queries. Reflections are completely transparent to data users. During the query process, the Dremio optimizer matches the best Reflections to accelerate the query. Performance for all queries is also accelerated using Columnar Cloud Cache (C3). C3 selectively caches only the data required to satisfy your workloads, eliminating 90% of I/O costs.

Blue speedometer maxed out
gnarly sql query code

Flexible, fast, lightweight data transformation

Reduce reliance on costly ETL tools and brittle, complex data pipelines. Dremio makes it easy to apply last mile data transformations, including filtering, sorting, aggregating, joining, casting. These transformations can be quickly built as Dremio Views - governed virtual data sets with layered transformations - that can be flexibly shared and modified for downstream data projects.

Federated querying for all your data, everywhere

Designed for interactive analytics and DML on the data lake, the Dremio SQL Query Engine makes it easy to analyze all of your data - whether on the data lake or in other data sources. Our connector ecosystem features dozens of integrations with an array of sources, including object storage, metastores, and databases in the cloud and on premises. Because Dremio queries your data at the source, there is no data movement, no data copies, and no complex ETL.

table priveleges checkmarks
gnarly dremio icon over cloud sources

Built for the Cloud, Multi-Cloud, on-premises, and hybrid environments

Query your data where it lives - whether in the Cloud, across clouds, on-premises, or in hybrid environments. Dremio understands that many organizations choose to distribute their workloads across different cloud platforms, allowing them to leverage the strengths of each provider while avoiding vendor lock-in. With Dremio, you can access all of your data to put it to analytic work in seconds.

Built on Apache Arrow for fastest performance

Dremio's SQL Query Engine, powered by Apache Arrow, is core to delivering the best price-performance for queries across all your data.In fact, Dremio developed Arrow and subsequently contributed it to the Apache Foundation. Arrow Flight is designed from the ground-up to support modern analytical workloads for columnar data structures and parallel processing. 

apache arrow logo white on black background

Ready to Get Started?

Bring your users closer to the data with organization-wide self-service analytics and lakehouse flexibility, scalability, and performance at a fraction of the cost. Run Dremio anywhere with self-managed software or Dremio Cloud.