Compare Oracle Autonomous Data Warehouse vs. Snowflake
Oracle Autonomous Data Warehouse is ranked 6th in Cloud Data Warehouse with 4 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 10 reviews. Oracle Autonomous Data Warehouse is rated 8.8, while Snowflake is rated 8.2. The top reviewer of Oracle Autonomous Data Warehouse writes "Saves time by allowing me to simply load my data and go". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". Oracle Autonomous Data Warehouse is most compared with Snowflake, Microsoft Azure SQL Data Warehouse and Amazon Redshift, whereas Snowflake is most compared with Microsoft Azure SQL Data Warehouse, Apache Hadoop and Amazon Redshift. See our Oracle Autonomous Data Warehouse vs. Snowflake report.
 |
Most Helpful Review | |||||
|
| ||||
 Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake and other solutions. Updated: March 2020. 408,459 professionals have used our research since 2012. | |||||
Quotes From Members
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros | |
The analytics have been very good. We've found them to be quite useful. I really like the auto-tuning, auto-scaling, and the automatic load balancing and query tuning in the system. I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW. Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets. | I like the idea that you can assign roles and responsibilities, limiting access to data. It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL. The snapshot feature is good, the rollback feature is good and the interface is user-friendly. The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services. The initial setup is straightforward. You just need to follow the documentation. They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises. The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications. As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes. |
Cons | |
Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable. I would like to see an on-premise solution in the future. 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. 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. | If you go with one cloud provider, you can't switch. They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in. Availability is a problem. Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway. The solution could improve the user interface and add functionality to the system. The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template. Support needs improvement, as it can take several days before you get some initial support. There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source. |
Pricing and Cost Advice | |
The cost is perfect with Oracle Universal credit. | You pay based on the data that you are storing in the data warehouse and there are no maintenance costs. The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year. Pricing can be confusing for customers. |
 Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs. 408,459 professionals have used our research since 2012. | |
Ranking  | |
Views 2,061 Comparisons 1,300 Reviews 4 Average Words per Review 366 Avg. Rating 8.8 | Views 20,612 Comparisons 14,262 Reviews 10 Average Words per Review 642 Avg. Rating 8.2 |
Top Comparisons | |
 Compared 33% of the time.  Compared 30% of the time.  Compared 24% of the time. | Compared 23% of the time.  Compared 21% of the time. Compared 11% of the time. |
Also Known As | |
| Snowflake Computing | |
Learn | |
| Oracle Video Not Available | Snowflake Computing |
Overview | |
Autonomous Data Warehouse is market-leading Oracle Database software running on proven Oracle Exadata infrastructure that is optimized to deliver unbeatable performance for data warehouse workloads. Built-in adaptive machine learning eliminates manual labor for administrative management. With Oracle, business and enterprise users can now build their own data warehouse, data mart, or sandbox in a few minutes. | Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed. |
Offer | |
Learn more about Oracle Autonomous Data Warehouse | Learn more about Snowflake |
Sample Customers | |
| Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank | Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops |
Top Industries | |
Software R&D Company64% Comms Service Provider10% K 12 Educational Company Or School4% Construction Company4% | Software R&D Company40% Comms Service Provider9% Retailer6% Insurance Company6% |
Company Size | |
No Data Available | Small Business20% Midsize Enterprise20% Large Enterprise60% Small Business4% Midsize Enterprise10% Large Enterprise86% |
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake and other solutions. Updated: March 2020.
408,459 professionals have used our research since 2012.
See also Oracle Autonomous Data Warehouse Reviews, Snowflake Reviews, and our list of Best Cloud Data Warehouse Companies.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post
reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference
with LinkedIn, and personal follow-up with the reviewer when necessary.