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

Oracle Autonomous Data Warehouse vs Snowflake Analytics comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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

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
Snowflake Analytics
Ranking in Cloud Data Warehouse
11th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
44
Ranking in other categories
Web Analytics (6th)
 

Mindshare comparison

As of November 2026, in the Cloud Data Warehouse category, the mindshare of Oracle Autonomous Data Warehouse is 4.1%, down from 5.3% compared to the previous year. The mindshare of Snowflake Analytics is 3.6%, up from 1.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Mindshare Distribution
ProductMindshare (%)
Snowflake Analytics3.6%
Oracle Autonomous Data Warehouse4.1%
Other92.3%
Cloud Data Warehouse
 

Featured Reviews

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…
Hemanthreddy Vakiti - PeerSpot reviewer
Data Engineer at a tech vendor with 10,001+ employees
Daily restaurant dashboards have become faster and now support simultaneous team analytics
Some of the best features of Snowflake Analytics is how it is separated for compute and storage, which allows multiple teams to run queries without performance impact. Our project has more than nine or ten teams, so if a team is working on a particular dashboard and another team wants to work on Snowflake Analytics, they can easily work on it without disturbing the work of one team, ensuring that the work can be consistent and multiple users can use the tool simultaneously. This is one of the main features I appreciate about Snowflake Analytics.The other aspect is how the query performance is high due to its columnar storage and also automatic optimization, allowing for scaling down during weekdays when there is less data and scaling up during weekends or festivals when the data can be huge. Because of this automatic scaling, if there is less data, we are using only 5 GB instead of 10 GB, which reduces the storage level, and consequently, the cost can be reduced. This automatic scaling and optimization saves us a huge amount of money for our project. Snowflake Analytics has impacted our organization positively by providing faster query performance and better scalability. Previously, we faced issues with slow queries due to traditional systems, but within Snowflake, we can assign separate virtual warehouses for reporting as well as data processing, ensuring that it does not impact tool performance and does not delay reporting to business users. Analysts can run complex queries without affecting ETL workloads due to this separation, which has improved our speed of reporting, and our business users have expressed happiness due to how fast we are generating reports during peak hours.

Quotes from Members

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

Pros

"The product is easy to use."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"I highly recommend it for companies who want to test their application functionality, dev, or test DBs for cost optimization."
"The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people."
"The product has self-repair features."
"The autonomous database provides several benefits and unmatched performance."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"Deployment is straightforward as it's a SaaS product. No maintenance required."
"The solution auto-scales and provides concurrency, you can have different virtual warehouses without them impacting each other, and it's flexible and infinitely scalable because it's on the cloud."
"Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
"Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning."
"The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for dashboarding purposes."
"It's cloud-based technology, so users can spin it up a lot faster"
"I am impressed with the product's data-sharing feature."
"The latest interface of Snowsight UI has added good capabilities and the interface is excellent."
 

Cons

"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"Optimization should be better."
"An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud."
"Oracle should increase visibility options because what's available now is limited."
"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."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"Ease of interconnectivity could be improved by which I mean setting up the VPN access and the like from on-premises to cloud."
"The platform's data governance space needs more capability."
"For modeling of data as well as for AI and predictive analytics, they need to improve their integration into different Python and Jupyter notebooks."
"The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises."
"Integration into different Python and Jupyter notebooks needs to be improved."
"I cannot comment on the product's stability because we are still struggling with its performance."
"There are issues while loading data from Snowflake Analytics to the Power BI reporting, and it doesn't get loaded directly."
"We haven't seen any areas that are lacking."
"The solution’s scalability could be improved."
 

Pricing and Cost Advice

"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."
"In terms of architecture and pricing structure, I feel it is a little bit costly compared to Azure. It's fine compared to RedShift, but compared to Azure, it's a bit pricey when you calculate for one TB storage plus around five hours of reporting with the frequency of 1TB data. The cost adds up, making Oracle a bit expensive."
"The solution's cost is reasonable."
"The cost is perfect with Oracle Universal credit."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"You pay as you go, and you don't pay for services that you don't use."
"The solution is expensive."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The product's pricing is subjective."
"Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query."
"The cost of Snowflake Analytics is low, any small organization can use it."
"It is not overly expensive. I would rate the pricing a six out of ten, with ten being expensive."
"The pricing is on the higher side."
"It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
"I have been using free trial version."
"When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
920,769 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
12%
Media Company
10%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
16%
Outsourcing Company
14%
Financial Services Firm
11%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business7
Midsize Enterprise1
Large Enterprise11
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise13
Large Enterprise23
 

Questions from the Community

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.
What is your experience regarding pricing and costs for Snowflake Analytics?
The pricing for Snowflake Analytics is reasonable, but as I am not part of the management team, I am not certain about our organization's exact costs. Overall, the return on investment for this too...
What needs improvement with Snowflake Analytics?
One improvement Snowflake Analytics could benefit from is in cost, particularly during peak hours. Sometimes, due to its automatic scalability, we think it has scaled up, but it does not always hap...
What is your primary use case for Snowflake Analytics?
I am using Snowflake Analytics because we are already using Snowflake for data engineering and data warehousing tasks, and we are using it for analytics as well as business intelligence reporting. ...
 

Overview

 

Sample Customers

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake Analytics and other solutions. Updated: September 2026.
920,769 professionals have used our research since 2012.