No more typing reviews! Try our Samantha, our new voice AI agent.

Dremio vs Oracle Autonomous Data Warehouse comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Feb 15, 2026

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Dremio
Ranking in Cloud Data Warehouse
10th
Average Rating
8.4
Reviews Sentiment
6.5
Number of Reviews
14
Ranking in other categories
Data Science Platforms (9th)
Oracle Autonomous Data Ware...
Ranking in Cloud Data Warehouse
14th
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2026, in the Cloud Data Warehouse category, the mindshare of Dremio is 4.3%, down from 7.8% compared to the previous year. The mindshare of Oracle Autonomous Data Warehouse is 4.1%, down from 5.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Mindshare Distribution
ProductMindshare (%)
Dremio4.3%
Oracle Autonomous Data Warehouse4.1%
Other91.6%
Cloud Data Warehouse
 

Featured Reviews

Baptiste Bergelin - PeerSpot reviewer
Data Architect at a consultancy with 51-200 employees
Data platform has unified diverse sources for mesh use but has needed query cache tuning
We contact the technical support at least weekly; currently, it's more or less daily because we face performance issues, crashes of queries sometimes, and we also need support for configuration of the query engines and so on. We are using the support extensively, and we are under a Gold support plan. The quality and speed of the support are satisfactory. Sometimes it depends on which support engineer is taking up the case, but very often it's quite responsive, reactive, coherent, and the response is of good quality. I would give the support an eight on a scale from one to ten, with ten being the highest.
reviewer1297710 - PeerSpot reviewer
IT Administrator at a manufacturing company with 1,001-5,000 employees
Analytics and data security needs are met but optimization requires improvement
We are using Oracle Autonomous Data Warehouse for analytics in my company The solution is used for analytics and it works for our data security needs. We continue to use it with satisfaction. Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The primary value I find in Dremio is that this tool is mainly used to query data that are split amongst several sources and to virtualize those sources so that the end user faces it as a single source of truth of data."
"Dremio enables you to manage changes more effectively than any other data warehouse platform. There are two things that come into play. One is data lineage. If you are looking at data in Dremio, you may want to know the source and what happened to it along the way or how it may have been transformed in the data pipeline to get to the point where you're consuming it."
"The most valuable feature of Dremio is it can sit on top of any other data storage, such as Amazon S3, Azure Data Factory, SGFS, or Hive. The memory competition is good. If you are running any kind of materialized view, you'd be running in memory."
"It's almost similar, yet it's better than Starburst in spinning up or connecting to the new source since it's on SaaS."
"Dremio has positively impacted my organization by helping us create a single source of truth, a singular data warehouse where we can have access to all of the data sets."
"Dremio has positively impacted my organization as nowadays we are connected to multiple databases from multiple environments, multiple APIs, and applications, and Dremio organizes everything in an amazing way for me."
"Dremio allows querying the files I have on my block storage or object storage."
"Overall, you can rate it as eight out of ten."
"The product has self-repair features."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"The autonomous database provides several benefits and unmatched performance."
"The solution is used for analytics and it works for our data security needs."
"The solution integrates well with Power BI."
"I like the fact that the solution is self-patching, that it's running machine-learning generally across its logs all the time in order to identify any issues and to self-repair."
 

Cons

"They have an automated tool for building SQL queries, so you don't need to know SQL. That interface works, but it could be more efficient in terms of the SQL generated from those things. It's going through some growing pains. There is so much value in tools like these for people with no SQL experience. Over time, Dermio will make these capabilities more accessible to users who aren't database people."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries. Additionally, the solution could improve if we could read data from the streaming pipelines or if it allowed us to create the ETL pipeline directly on top of it, similar to Snowflake."
"Dremio takes a long time to execute large queries or the executing of correlated queries or nested queries."
"Dremio doesn't support the Delta connector. Dremio writes the IT support for Delta, but the support isn't great. There is definitely room for improvement."
"They need to have multiple connectors. Starburst is rich in connectors, however, they are lacking Salesforce connectivity as of today."
"There are performance issues at times due to our limited experience with Dremio, and the fact that we are running it on single nodes using a community version."
"They need to have multiple connectors."
"Dremio could be improved by making it easier for data cataloging, especially when working with open table formats, as you have to choose a data format and then go into it."
"I would like to see an on-premise solution in the future."
"The installation process is complex. Oracle can make the installation process better."
"One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace creation, which could cause issues during on-premise database migration that requires specifically named tablespace. There should be an option to create customized tablespace."
"My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle."
"Ease of connectivity could be improved."
"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
 

Pricing and Cost Advice

"Dremio is less costly competitively to Snowflake or any other tool."
"Right now the cluster costs approximately $200,000 per month and is based on the volume of data we have."
"The cost is perfect with Oracle Universal credit."
"The price depends on the configuration we choose."
"The solution is expensive."
"On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The solution's cost is reasonable."
"The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
"ROI is high."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
921,840 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Outsourcing Company
9%
Comms Service Provider
8%
Manufacturing Company
6%
Financial Services Firm
12%
Media Company
10%
Manufacturing Company
8%
Outsourcing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business3
Midsize Enterprise6
Large Enterprise5
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise1
Large Enterprise11
 

Questions from the Community

What is your experience regarding pricing and costs for Dremio?
Dremio does have a core of the engine that is open-source, but all the important features for the enterprise version are under license. Regarding the license and pricing, we have an agreement, a co...
What needs improvement with Dremio?
Something I dislike about it is the performance optimization concerning a special feature known as Reflection, Data Reflection, which is basically a cache of the data sources behind it. This Reflec...
What is your primary use case for Dremio?
As the data platform architect, I use Dremio as the main component of our platform to serve our business needs, acting as an integrator and as a meta user of it. My colleagues use it to serve their...
What is your experience regarding pricing and costs for Oracle Autonomous Data Warehouse?
We pay approximately $70,000 per month. The cost includes maintenance and support.
What needs improvement with Oracle Autonomous Data Warehouse?
Optimization should be better. The SQLs are sometimes very slow. I also noticed that Java is not supported, which is not ideal.
What is your primary use case for Oracle Autonomous Data Warehouse?
We are using Oracle Autonomous Data Warehouse for analytics in my company.
 

Also Known As

Dremio AWS - BYOL
No data available
 

Overview

 

Sample Customers

UBS, TransUnion, Quantium, Daimler, OVH
Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Find out what your peers are saying about Dremio vs. Oracle Autonomous Data Warehouse and other solutions. Updated: November 2026.
921,840 professionals have used our research since 2012.