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

Oracle Autonomous Data Warehouse vs Snowflake 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
Ranking in Cloud Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
99
Ranking in other categories
Data Warehouse (1st), AI Synthetic Data (3rd)
 

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 is 20.5%, down from 22.8% 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.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

Quotes from Members

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

Pros

"It is a stable and scalable solution."
"The solution is used for analytics and it works for our data security needs."
"One advantage is that if you already have an Oracle Database, it easily integrates with that."
"It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues."
"A very good integration feature that restricts access to unauthorized people."
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets."
"The performance and scalability are awesome."
"It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions."
"The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power."
"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"The tool is very easy to use. The solution’s desktop features are also very easy to use. Also, the product’s SQL-based connectivity is also good. It can connect with any tool."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"I don't think it is difficult to maintain."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
 

Cons

"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."
"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."
"The installation process is complex. Oracle can make the installation process better."
"The solution lacks visibility options."
"Optimization should be better."
"I would like to see an on-premise solution in the future."
"Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable."
"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."
"Pricing is an issue for many customers."
"The product is not very cheap, and a reduction in costs would be appreciated."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"Availability is a problem."
"The price could be improved."
"The design of the product is easily misunderstood."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
"Product activation queries can't be changed while executing."
 

Pricing and Cost Advice

"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."
"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."
"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."
"Oracle Autonomous Data Warehouse's pricing is fair and reasonable compared to the other cloud vendors."
"You pay as you go, and you don't pay for services that you don't use."
"The solution is expensive."
"We pay approximately $70,000 per month. The cost includes maintenance and support."
"The solution is expensive but worth the cost because the quality is there."
"It is pay-as-you-go. Its cost is in the medium range."
"I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production."
"We're based on credits. So, we're paying four and a half dollars of credit. There are no additional costs. I would rate it a two out of five in terms of pricing."
"Snowflake’s pricing is transparent. It is one of the cheapest cloud database warehouse providers. The tool follows a credit cost model. Everything on Snowflake is charged on the basis of credits. The credits depend on the cloud region and the public cloud provider that we use. Hence, the cost per credit will be different for AWS in Frankfurt and AWS in India. I think North Virginia is the cheapest region in terms of cost per credit. You will be consuming around 16 credits for large data warehouses."
"You pay based on the data that you are storing in the data warehouse and there are no maintenance costs."
"Snowflake is cost-effective."
"I have worked with multiple clouds, and cost-wise, it is a bit costlier than others, such as Redshift. Its price should be reduced."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
842,767 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
49%
Financial Services Firm
8%
Computer Software Company
7%
Manufacturing Company
4%
Educational Organization
40%
Financial Services Firm
12%
Computer Software Company
8%
Manufacturing Company
5%
 

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 do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
Snowflake's pricing is on the higher side, rated as eight out of ten. If there were ways to reduce costs, it would be a positive improvement.
What needs improvement with Snowflake?
Cost reduction is one area I would like Snowflake to improve. The product is not very cheap, and a reduction in costs would be appreciated.
 

Also Known As

No data available
Snowflake Computing
 

Overview

 

Sample Customers

Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake and other solutions. Updated: March 2025.
842,767 professionals have used our research since 2012.