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 performance and scalability are awesome."
"I highly recommend it for companies who want to test their application functionality, dev, or test DBs for cost optimization."
"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"It is a stable and scalable solution."
"The solution has a self-backup, so you don't need a DBA (database administrator) to do a backup."
"The autonomous database provides several benefits and unmatched performance."
"The analytics have been very good. We've found them to be quite useful."
"The integration feature is very good because you can automate protection security automatically, restricting the access of unauthorized people."
"Snowflake Analytics has a bright future and is capturing the market across various domains such as life sciences, BFSI, and supply chain."
"I am impressed with the product's data-sharing feature."
"Snowflake Analytics is flexible in nature, allowing for the addition of more data tables without affecting the main structure."
"Snowflake Analytics has positively impacted our organization by saving about eight to ten hours per week, which we can use for advanced analytics and automation tasks."
"It is a wonderful tool that easily organizes data, makes it accessible, loads it from the pipeline, and helps with reporting."
"We have experienced a 40 to 50% improvement in ROI compared to legacy systems."
"It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."
"The most important feature is the warehouse functionality."
 

Cons

"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."
"Ease of connectivity could be improved."
"It is good as data warehouses go, but it is not that good for really big data."
"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 setup is complex."
"Ease of interconnectivity could be improved by which I mean setting up the VPN access and the like from on-premises to cloud."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"We were experiencing errors while running reports and making connections."
"Navigating the user console can be challenging, particularly when looking for details like the account ID."
"I don't see many drawbacks with Snowflake Analytics, but it's not as mature as other tools. It is evolving and needs to integrate various features, like data loading and analytics, better. These components are not fully connected, so the tool should become a more integrated application."
"The pricing visibility is complex. If you understand pricing, you can estimate costs, but if not, it can be challenging."
"The solution's high price can be an area of concern that needs improvement."
"The solution’s scalability could be improved."
"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."
 

Pricing and Cost Advice

"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."
"The solution's cost is reasonable."
"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."
"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."
"ROI is high."
"You pay as you go, and you don't pay for services that you don't use."
"Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
"The cost is perfect with Oracle Universal credit."
"Snowflake Analytics is a little more costly than Azure."
"I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price."
"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."
"The product's pricing is subjective."
"The solution's price is high and I would rate it an eight out of ten."
"On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high."
"The solution's pricing is affordable."
"It's not costly if you configure it properly to ensure optimal performance. People don't configure it properly, which is why costs go up."
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.