Compare Oracle Autonomous Data Warehouse vs. Snowflake

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake and other solutions. Updated: January 2021.
466,310 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
"Oracle Autonomous Data Warehouse is used globally to deliver extreme performance on large Financial data sets.""I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.""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 provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""Self-patching and runs machine-learning across its logs all the time""The solution integrates well with Power BI."

More Oracle Autonomous Data Warehouse Pros »

"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.""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.""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 initial setup is straightforward. You just need to follow the documentation.""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.""It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.""I like the idea that you can assign roles and responsibilities, limiting access to data.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."

More Snowflake Pros »

Cons
"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.""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.""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.""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.""The initial setup was pretty complex. It was not easy."

More Oracle Autonomous Data Warehouse Cons »

"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.""Support needs improvement, as it can take several days before you get some initial support.""The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.""The solution could improve the user interface and add functionality to the system.""Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.""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.""If you go with one cloud provider, you can't switch.""Availability is a problem."

More Snowflake Cons »

Pricing and Cost Advice
"The cost is perfect with Oracle Universal credit.""ROI is high."

More Oracle Autonomous Data Warehouse Pricing and Cost Advice »

"Pricing can be confusing for customers.""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.""You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.""It is not cheap.""The pricing for Snowflake is competitive.""On average, with the number of queries that we run, we pay approximately $200 USD per month.""Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month.""The price of Snowflake is very reasonable."

More Snowflake Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
466,310 professionals have used our research since 2012.
Questions from the Community
Top Answer: It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.
Top Answer: An ADB serverless service provides no control over storage, host, and facilities. One of the major problem is creating custom tablespace. The ADB serverless option doesn't support custom tablespace… more »
Top Answer: Oracle offers this solution as Platform as a service (PaaS). The serverless option provides cost optimization to the organization where they can save huge amounts of money, but not require a highly… more »
Top Answer: The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
Top Answer: The primary use case is big data warehouses.
Ranking
5th
Views
4,237
Comparisons
3,028
Reviews
7
Average Words per Review
507
Rating
8.6
1st
Views
33,326
Comparisons
23,196
Reviews
28
Average Words per Review
586
Rating
8.3
Popular Comparisons
Also Known As
Snowflake Computing
Learn More
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
VISITORS READING REVIEWS
Computer Software Company55%
Comms Service Provider11%
Financial Services Firm4%
Media Company3%
REVIEWERS
Computer Software Company36%
Manufacturing Company14%
Financial Services Firm14%
Media Company7%
VISITORS READING REVIEWS
Computer Software Company32%
Comms Service Provider15%
Financial Services Firm7%
Media Company5%
Company Size
REVIEWERS
Small Business38%
Large Enterprise63%
REVIEWERS
Small Business31%
Midsize Enterprise17%
Large Enterprise51%
VISITORS READING REVIEWS
Small Business7%
Midsize Enterprise14%
Large Enterprise79%
Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake and other solutions. Updated: January 2021.
466,310 professionals have used our research since 2012.

Oracle Autonomous Data Warehouse is ranked 5th in Cloud Data Warehouse with 7 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 30 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Snowflake is rated 8.4. The top reviewer of Oracle Autonomous Data Warehouse writes "Self-patching means I generally don't need a DBA; detailed analytics make it very capable". 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 Microsoft Azure Synapse Analytics, Amazon Redshift, Teradata, Apache Hadoop and Oracle Exadata, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Firebolt, Amazon Redshift, Teradata and Oracle Exadata. See our Oracle Autonomous Data Warehouse vs. Snowflake report.

See our list of best Cloud Data Warehouse vendors.

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.