Oracle Autonomous Data Warehouse vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
3,362 views|2,210 comparisons
100% willing to recommend
Snowflake Computing Logo
493 views|330 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Autonomous Data Warehouse and Snowflake Analytics based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Oracle Autonomous Data Warehouse vs. Snowflake Analytics Report (Updated: March 2024).
770,141 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"A very good integration feature that restricts access to unauthorized people.""It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.""It is a stable and scalable solution.""It is a very stable tool...It is an extremely scalable tool.""It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""I loved the simplicity of loading the data and simply relying on the self-tuning capabilities of ADW.""The performance and scalability are awesome.""The product is easy to use."

More Oracle Autonomous Data Warehouse Pros →

"The solution auto-scales and it provides concurrency.""The most valuable feature of Snowflake Analytics is the ability to control and manage the cost.""Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning.""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 most valuable feature of Snowflake Analytics is its performance.""Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company.""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.""It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."

More Snowflake Analytics Pros →

Cons
"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.""I would like to see an on-premise solution in the future.""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.""Sometimes the solution works differently between the cloud and on-premises. It needs to be more consistent and predictable.""The solution lacks visibility options.""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.""They should make the solution more user-friendly.""The installation process is complex. Oracle can make the installation process better."

More Oracle Autonomous Data Warehouse Cons →

"Implementing everything on-premise is challenging because it require proper support from advisors, DBAs, and others.""The platform's data governance space needs more capability.""A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark. An additional feature I'd like to see in the next release of the solution is built-in analytics.""The UI could be more user-friendly.""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.""Snowflake should include a WHERE clause for building data pipelines.""Integration into different Python and Jupyter notebooks needs to be improved.""The platform could work easier for AI implementation compared to one of its competitors."

More Snowflake Analytics Cons →

Pricing and Cost Advice
  • "The cost is perfect with Oracle Universal credit."
  • "ROI is high."
  • "You pay as you go, and you don't pay for services that you don't use."
  • "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."
  • "The solution's cost is reasonable."
  • "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 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 price depends on the configuration we choose."
  • More Oracle Autonomous Data Warehouse Pricing and Cost Advice →

  • "Snowflake Analytics is a little more costly than Azure."
  • "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 solution's price is high and I would rate it an eight out of ten."
  • "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."
  • "It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
  • "The tool is quite expensive."
  • "Snowflake Analytics is not an expensive solution, and its pricing is average."
  • More Snowflake Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    770,141 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: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… more »
    Top Answer:Cost-wise, it's a solid seven out of ten. A bit costly, but it is a good tool.
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer:The pricing is on the higher side. I would rate it seven out of ten.
    Top Answer:The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms.
    Ranking
    10th
    Views
    3,362
    Comparisons
    2,210
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    6th
    Views
    493
    Comparisons
    330
    Reviews
    30
    Average Words per Review
    486
    Rating
    8.4
    Comparisons
    Learn More
    Overview

    Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.


    Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

    Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.

    To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.

    Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.

    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
    Top Industries
    REVIEWERS
    Computer Software Company27%
    Manufacturing Company18%
    Financial Services Firm18%
    Individual & Family Service9%
    VISITORS READING REVIEWS
    Educational Organization43%
    Financial Services Firm9%
    Computer Software Company8%
    Manufacturing Company4%
    REVIEWERS
    Computer Software Company31%
    Financial Services Firm31%
    Outsourcing Company15%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm9%
    Manufacturing Company9%
    Retailer8%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise6%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise48%
    Large Enterprise39%
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise18%
    Large Enterprise63%
    Buyer's Guide
    Oracle Autonomous Data Warehouse vs. Snowflake Analytics
    March 2024
    Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. Snowflake Analytics and other solutions. Updated: March 2024.
    770,141 professionals have used our research since 2012.

    Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while Snowflake Analytics is rated 8.4. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". On the other hand, the top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our Oracle Autonomous Data Warehouse vs. Snowflake Analytics 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.