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
8th
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Web Analytics (1st)
 

Mindshare comparison

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

Featured Reviews

Miodrag Milojevic - PeerSpot reviewer
A tool for data warehousing that offers scalability, stability, and ease of setup
The initial setup of Oracle Autonomous Data Warehouse is easy and basic, especially if one doesn't use the tricks to get Oracle Exadata for use. One doesn't need to know or be involved in technical stuff to do the setup since, at the least, knowledge might be required when working with some external connections, but it is easy because everything can be done within a couple of clicks. The solution is deployed on the cloud. For deployment, you don't need any technical guidance since you can sit, find it on the web, and prepare an Oracle Autonomous Data Warehouse platform by yourself for free for a limited time. The people needed for the deployment and maintenance depend on the implementation one wants. If you do a simple implementation, you don't need anybody for maintenance since everything is on the cloud. You only have to schedule your backup or see if Oracle can schedule a backup, and you don't take care of the backup. For some more sophisticated or technical implementations, you will need staff for some data warehouse except for some parts of the maintenance like backup, patches, or upgrades since these are a few things you take care of in the background, and you only seek help with the maintenance part, if needed.
KamleshPant - PeerSpot reviewer
Data ecosystem thrives with advanced governance and streaming capabilities
It is a data offering where I can see data lineage, data governance, and data security. Snowflake has a streaming capability to work with real-time streaming data and delta tables. Additionally, task management, job scheduling, and connecting multiple data sources unify my data across internal and external sources. The system ecosystem for analytics is enhanced, and AI capabilities are incorporated.

Quotes from Members

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

Pros

"I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system."
"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."
"The solution integrates well with Power BI."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The product is easy to use."
"The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"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."
"Its performance speed is very good."
"It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning."
"The most valuable feature of Snowflake Analytics is the ability to control and manage the cost."
"It's not necessary to use a physical server."
"Snowflake Analytics' predictive analytics elements, which incorporate AI, are good and easy to integrate."
"What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all."
"The performance has been good."
 

Cons

"It is very important the integration with other platforms be made to be as easy as it is with an on-premises deployment."
"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 setup is complex."
"Oracle Autonomous Data Warehouse is not available as an on-premises solution."
"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."
"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."
"The solution lacks visibility options."
"The solution could be improved by allowing for migration tools from other cloud services, including migration from Amazon Redshift, RDS, and Aurora."
"The UI must be improved."
"Snowflake Analytics should probably have more built-in tools for master data management."
"The platform's data governance space needs more capability."
"Snowflake could improve in the areas of advanced machine learning AML and generative AI."
"The pricing visibility is complex. If you understand pricing, you can estimate costs, but if not, it can be challenging."
"Navigating the user console can be challenging, particularly when looking for details like the account ID."
"The platform could work easier for AI implementation compared to one of its competitors."
"The solution’s interface is good but it could be improved."
 

Pricing and Cost Advice

"The cost is perfect with Oracle Universal credit."
"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."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"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 is expensive."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"The price depends on the configuration we choose."
"The tool is quite expensive."
"I have been using free trial version."
"I rate the product's licensing cost a five or six on a scale of one to ten, where one is low price, and ten is high price."
"Snowflake Analytics is not an expensive solution, and its pricing is average."
"I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price."
"It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
"It is not overly expensive. I would rate the pricing a six out of ten, with ten being expensive."
"The solution's pricing is affordable."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
848,207 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
46%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
4%
Computer Software Company
19%
Retailer
13%
Financial Services Firm
9%
Manufacturing Company
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 is better and cheaper than Redshift and other cloud warehousing systems. It's economical.
What needs improvement with Snowflake Analytics?
Most features are already available. Perhaps AIML integration might be further needed, or Snowflake is already implementing it. AIML-based SQL prompt and query generation could be an area for enhan...
 

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: March 2025.
848,207 professionals have used our research since 2012.