Try our new research platform with insights from 80,000+ expert users

Oracle Autonomous Data Warehouse vs Snowflake Analytics comparison

 

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
10th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
19
Ranking in other categories
No ranking in other categories
Snowflake Analytics
Ranking in Cloud Data Warehouse
9th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
40
Ranking in other categories
Web Analytics (1st)
 

Mindshare comparison

As of June 2025, in the Cloud Data Warehouse category, the mindshare of Oracle Autonomous Data Warehouse is 4.8%, up from 4.1% compared to the previous year. The mindshare of Snowflake Analytics is 0.6%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Kwajah Mohiuddin - PeerSpot reviewer
Provides self-repair features, but the setup is complex
We use the product for online applications. We use it in the financial industry The product has self-repair features. The tool tunes itself. It separates compute from storage. We can scale storage and compute separately. The setup is complex. Oracle is a complex tool. I have been using Oracle…
Paresh_Nayak - PeerSpot reviewer
Enables data-driven decision-making with robust features and effective scalability
The internal design engine and the columnar database are particularly valuable. These features reduce input and output memory, which is crucial in handling large data sets. The solution fulfills the business requirement for scaling and analytics. Snowflake Analytics supports data security with a single sign-on feature and complies with framework regulations, which is highly beneficial.

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."
"The solution is used for analytics and it works for our data security needs."
"I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW."
"The solution is used for analytics and it works for our data security needs."
"The product has self-repair features."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"The analytics have been very good. We've found them to be quite useful."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"One of the distinctive features of Snowflake is its ability to handle large datasets efficiently."
"One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten."
"Its performance speed is very good."
"It can run complex workloads with varied compute."
"Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
"The most valuable feature of Snowflake Analytics is its performance."
"Features like the fact that the solution is very fast and available on the cloud are some of the valuable attributes of the solution."
"The most valuable feature of Snowflake Analytics is the ability to control and manage the cost."
 

Cons

"The initial setup was pretty complex. It was not easy."
"There is a need for more storage to be allocated, but over a period of time, it becomes impossible to reduce it after using it."
"The installation process is complex. Oracle can make the installation process better."
"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."
"The setup is complex."
"It doesn't work well when you have unstructured data or you need online analytics. It is not as nice as Hadoop in these aspects."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"Machine learning in Snowflake isn't as advanced as in other products. I haven't heard of any successful industry-wide use cases of machine learning implemented in Snowflake. It might take a couple of years to reach the same level as Databricks."
"The technical support is not very good."
"Improvements are needed in importing and exporting large datasets to and from reporting tools."
"We haven't seen any areas that are lacking."
"There are issues while loading data from Snowflake Analytics to the Power BI reporting."
"The solution's high price can be an area of concern that needs improvement."
"The product's cost is an area of concern where improvements are required."
"The UI must be improved."
 

Pricing and Cost Advice

"We pay approximately $70,000 per month. The cost includes maintenance and support."
"ROI is high."
"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."
"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."
"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."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The solution is expensive."
"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 cost of Snowflake Analytics is low, any small organization can use it."
"The product's pricing is subjective."
"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 pricing is on the higher side."
"It is not overly expensive. I would rate the pricing a six out of ten, with ten being expensive."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
859,129 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
26%
Financial Services Firm
11%
Computer Software Company
8%
Manufacturing Company
5%
Computer Software Company
17%
Retailer
11%
Financial Services Firm
10%
Government
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Autonomous Data Warehouse?
With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main...
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 experience regarding pricing and costs for Snowflake Analytics?
Snowflake Analytics is quite economical. It does not appear to incur significant extra expenses beyond the solution's initial cost. However, a complete pricing analysis is still in progress.
What needs improvement with Snowflake Analytics?
The advantages of Snowflake Analytics outweigh the disadvantages. However, if it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it wo...
 

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: June 2025.
859,129 professionals have used our research since 2012.