About Dremio OSS
Dremio is a data analytics platform aimed at organizations that want to query and analyze large volumes of data without first moving or copying it into a separate, dedicated analytics database. It positions itself as filling a gap between raw data storage and the tools people need to get value out of that data.
The open-source edition can be built and run locally, exposing a web UI at localhost:9047 once started, or installed as a production tarball for server deployment, with an embedded mode also available. Building it requires a specific combination of JDK versions (21 as default, with 17 and 11 configured in the Maven toolchain for certain tests) plus Maven, reflecting a substantial, enterprise-grade Java codebase.
The README notes that to provide the best possible experience, the build includes some dependencies distributed under non-open-source licenses, so the fully open-source experience may differ slightly depending on build configuration. Dremio is written in Java and the open-source edition is released under the Apache-2.0 license, with full documentation hosted separately.
Key features
- SQL analytics directly on lake and warehouse data
- Web-based query interface
- Local and production deployment modes
- Built on a Java codebase with Maven tooling
- No data duplication required for analytics
Good fit for
- Querying data lakes with SQL without ETL
- Self-hosted analytics on existing data storage
Dremio OSS: questions and answers
- What is Dremio OSS used for?
- Dremio OSS is a free, Apache-licensed, open-source data lakehouse platform in Java that provides fast SQL analytics directly on data stored in warehouses and lakes. It is a good fit for querying data lakes with SQL without ETL and self-hosted analytics on existing data storage.
- Is Dremio OSS open source?
- Yes. Dremio OSS is open source under the Apache-2.0 licence. Its source code is on GitHub at dremio/dremio-oss and is written mainly in Java.
- Is Dremio OSS free?
- Yes. Dremio OSS is open source, so the software itself is free to use.
- Can I self-host Dremio OSS?
- Yes. Dremio OSS can be self-hosted on your own server or infrastructure; there is no official hosted version.
- What is Dremio OSS an alternative to?
- Dremio OSS is an open-source alternative to Snowflake, Databricks, Google BigQuery and Amazon Redshift. Other open-source alternatives to Snowflake include Trino, ClickHouse and StarRocks.
- Is Dremio OSS actively maintained?
- The most recent commit to Dremio OSS was on 26 September 2025. The project has 1.5k stars on GitHub, with 2 added in the last 30 days.
Open-source alternatives to Dremio OSS
See all
Trino
Databases
Official repository of Trino, the distributed SQL query engine for big data, formerly know
Apache-2.0vs Amazon Redshift★ 14k
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 51k
StarRocks
Databases
The world's fastest open query engine for sub-second analytics both on and off the data la
Apache-2.0vs Snowflake★ 12k
Apache Hive
Databases
Apache Hive
Apache-2.0vs Snowflake★ 6k
Apache Doris
Databases
Apache Doris is a real-time analytics and hybrid search database for AI agents.
Apache-2.0vs Snowflake★ 16k
Databend
Databases
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt fr
OSSvs Snowflake★ 9.5k
SaaS alternatives to Dremio OSS
See all
Snowflake
Databases
Cloud data platform for warehousing, data sharing and analytics
SaaS
Databricks
Data Pipelines & ETL
Lakehouse platform for data engineering, analytics and machine learning
SaaS
Google BigQuery
Databases
Serverless data warehouse for SQL analytics on large datasets
SaaS
Amazon Redshift
Databases
Managed cloud data warehouse on AWS for SQL analytics at scale
SaaSDenodo
Data Pipelines & ETL
Data virtualization and logical data management platform
SaaS
Microsoft Fabric
Data Pipelines & ETL
Unified analytics platform combining data engineering, warehousing and Power BI
SaaS

Teradata
Amazon Athena
Azure Synapse Analytics
Starburst
Cloudera
Tinybird
MotherDuck
Funnel
Dataddo
Vertica
Firebolt
Holistics
Yellowbrick
AtScale