Self-Service SQL Analytics.
Open Data Lakehouse.
Sub-Second Performance.

why dremio screenshot 1

What is a Data Lakehouse?

A data lakehouse combines the performance, functionality and governance of a data warehouse with the scalability and cost advantages of a data lake.

With a data lakehouse, engines can access and manipulate data directly from data lake storage without copying data into expensive proprietary systems using ETL pipelines.

Learn more about data lakehouses ->

Dremio Overview

1 min

Meet Dremio

The Easy and Open Data Lakehouse

Dremio is an open data lakehouse, providing self-service analytics, data warehouse performance and functionality, and data lake flexibility across all of your data.

The Only Data Lakehouse with Self-Service SQL Analytics

Dremio is the only data lakehouse that empowers data engineers and analysts with easy-to-use self-service SQL analytics.

magnifying glass icon

Unified View of Data

Easily connect to all of your data sources and expose the data through a unified business-friendly data model. Unified data improves data discovery, ensures consistent reporting and enables governed self-service data access.

SQL table icon

Built For SQL

Query data from any SQL client (e.g., BI tools) and build data integration and consumption workflows using just SQL.

colorful table icon

Modern and Intuitive User Interface

Create new data views, calculate new columns, see which datasets compose each view, and add descriptions and tags to datasets with just a few clicks.

Product Feature
Here’s What Delivers Self-Serve SQL Analytics
list-icon Semantic layer (Search | Lineage | Built-in Catalog)
list-icon Intuitive SQL & no-code user interface
list-icon Data source connectors
list-icon BI connectors
list-icon Data integration & consumption workflows using just SQL
list-icon Easy-to-configure security & access control
logo leap energy
“Dremio gets rid of all the technical barriers to accessing data. What now takes 20 seconds would have previously required a day of work. It was amazing how quickly productivity improved when analysts could quickly and easily query and organize data themselves.”

Marco Rietveld

Lead Data Engineer | Leap Energy

logo forrester 1
“Dremio improves the data engineers’ productivity by 30%, which leads to more than 3,000 hours in annual time savings. Of the time saved, the data engineers recapture 75% to put toward additional work efforts.”

Forrester Total Economic Impact Report

Completely Open Data, No Lock-In

An open data lakehouse, based on community-driven standards like Apache Parquet, Apache Iceberg and Apache Arrow, enables organizations to use best-in-class processing engines and eliminates vendor lock‑in.

layers icon

Comprehensive Support for Apache Iceberg

Apache Iceberg is the most broadly supported open table standard, with read/write support in Dremio Sonar and other popular engines with 2x the contributions of Delta Lake.

right arrow icon

Co-creators of Apache Arrow

Apache Arrow is the standard in-memory data representation that every query engine can use. It enables high performance queries and makes data sharing seamless across platforms. Apache Arrow is downloaded 70 million times per month.

logo otpbank 1
“Dremio’s deep integration with open data standards is a huge advantage for us. When you decide to change the infrastructure of your data, you don’t need to impact your reporting layer. Having an open and independent data lakehouse enables us to play with different solutions, and we can optimize for cost, time to market and easily move data back and forth. All this can be done in the backend without affecting the business.”

Lotar Schin

Big Data Team Lead | OTP Bank

Open Data Projects We Actively Support

logo iceberg
logo apache arrow 1
logo apache calcite 1
logo parquet 1

Sub-Second Performance, 1/10th the Cost of Cloud Data Warehouses

Dremio provides customers with sub-second SQL queries for BI on the data lakehouse, unmatched by other engines. Dremio exceeds the performance and scale requirements of the most demanding and largest enterprises in the world, including 5 of the Fortune 10.

clock icon

Sub-Second Performance

Apache Arrow and Data Reflections, patent-pending optimization technology, combine to deliver the fastest query engine performance.

concurrency icon

High Concurrency

High Concurrency and the ability to run multiple query patterns simultaneously is achieved with Workload Management (WLM) and the Dremio auto scaling multi-engine architecture.

money icon

1/10th the Cost of Data Warehouses

Dremio combines excellent price-performance, low cost storage (e.g. Amazon S3), and the elimination of creating and managing data copies. In total, Dremio is less than 1/10th the cost of cloud data warehouses, such as Snowflake.

Here’s What Makes Dremio Sonar Query Engine the Fastest
list-icon Reflections
list-icon Arrow Inside
list-icon C3 cache (columnar data cache on DAS)
list-icon Cost-based Optimizer
list-icon Granular Pruning
list-icon The fastest JDBC, ODBC and ADBC drivers
list-icon Multi-engine Architecture
list-icon Workload Management
logo renaissancere 1
“We had a query in a production environment, it took 70 minutes to return. We put Dremio on top using Amazon S3, and we got the query down to 33 seconds, with Dremio Reflections, down to 3 seconds. Really shocking performance we got from Dremio, just super impressive. We were all blown away.”

Andy Kenna

SVP and Head of Data | RenaissanceRe

Flexible Deployment Options

cloud data lakehouse

Dremio Cloud

Open & fully managed data lakehouse

Best Option if your data is on AWS.  Forever Free Usage.

computer software environment

Dremio Software

Software for any environment

Download Dremio’s Community Edition

logo garvis 1
At Garvis, we’ve been a cloud-native company from day one, so we want to build an open data stack that enables us to scale quickly to support our customers. Dremio Cloud is a great solution for us as it lets us focus on our core expertise, while getting access to the latest Dremio features without any administration or IT operations management on our side. We are confident that this is a solution that scales along with our organization as we grow quickly, in terms of engine scalability, data lineage and governance, and enterprise-grade security.

Geert-Jan Van Den Bogaerde

Chief Technology Officer | Garvis

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.