No more typing reviews! Try our Samantha, our new voice AI agent.

Oracle Big Data Appliance vs Snowflake Analytics comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

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 Big Data Appliance
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
6
Ranking in other categories
Data Warehouse (13th)
Snowflake Analytics
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
44
Ranking in other categories
Web Analytics (6th), Cloud Data Warehouse (12th)
 

Featured Reviews

reviewer1031826 - PeerSpot reviewer
Analytics Lead at a tech vendor with 10,001+ employees
Platinum partnership leverages advanced storage and fosters seamless data integration
Areas of Oracle Big Data Appliance that can be improved include the pricing perspective because nowadays they have competition. We have so many technologies that have come to the market for less than even one-fourth or one-fifth of the Oracle price. For my side, the last time I worked with Oracle was in '21, '22. The price is a challenge that they have to look after. From the storage and data management perspective, I cannot recall anything that they have to improve, but they have to improve the visualization part significantly because they offer Oracle BI, which is an extremely not-matured application.
Hemanthreddy Vakiti - PeerSpot reviewer
Data Engineer at a tech vendor with 10,001+ employees
Daily restaurant dashboards have become faster and now support simultaneous team analytics
Some of the best features of Snowflake Analytics is how it is separated for compute and storage, which allows multiple teams to run queries without performance impact. Our project has more than nine or ten teams, so if a team is working on a particular dashboard and another team wants to work on Snowflake Analytics, they can easily work on it without disturbing the work of one team, ensuring that the work can be consistent and multiple users can use the tool simultaneously. This is one of the main features I appreciate about Snowflake Analytics.The other aspect is how the query performance is high due to its columnar storage and also automatic optimization, allowing for scaling down during weekdays when there is less data and scaling up during weekends or festivals when the data can be huge. Because of this automatic scaling, if there is less data, we are using only 5 GB instead of 10 GB, which reduces the storage level, and consequently, the cost can be reduced. This automatic scaling and optimization saves us a huge amount of money for our project. Snowflake Analytics has impacted our organization positively by providing faster query performance and better scalability. Previously, we faced issues with slow queries due to traditional systems, but within Snowflake, we can assign separate virtual warehouses for reporting as well as data processing, ensuring that it does not impact tool performance and does not delay reporting to business users. Analysts can run complex queries without affecting ETL workloads due to this separation, which has improved our speed of reporting, and our business users have expressed happiness due to how fast we are generating reports during peak hours.

Quotes from Members

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

Pros

"The best feature of Oracle Big Data Appliance, from a price perspective for the storage, is because they have technology called the ZFS technology; it offers huge storage with a decent price."
"Big Data responds to my needs."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"The most valuable feature is that it can be used in conjunction with Spark memory processing, and our processing time has gone to 20 minutes from what used to be two or three hours on the mainframe."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"This is a comprehensive solution that is easy to deploy."
"We could work on large unstructured datasets from different parts of the world on Facebook and Twitter to get better insights."
"Snowflake Analytics has positively impacted our organization by saving about eight to ten hours per week, which we can use for advanced analytics and automation tasks."
"The latest interface of Snowsight UI has added good capabilities and the interface is excellent."
"One of the distinctive features of Snowflake is its ability to handle large datasets efficiently."
"While we've done many complex implementations, Snowflake always has a way of simplifying things."
"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."
"Snowflake Analytics is flexible in nature, allowing for the addition of more data tables without affecting the main structure."
"Its performance speed is very good."
"The most important feature is the warehouse functionality."
 

Cons

"We need to display the results on our website. I think there is another product that joins with it to give you the possibility."
"The product should be simplified for the average user."
"Areas of Oracle Big Data Appliance that can be improved include the pricing perspective because nowadays they have competition; we have so many technologies that have come to the market for less than even one-fourth or one-fifth of the Oracle price."
"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"We had to pursue several performance tuning measures to bring up the system to scale."
"If you have a lot of computations, Snowflake becomes costlier."
"The solution’s scalability could be improved."
"The solution needs to consider including some updates in the future."
"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 platform could work easier for AI implementation compared to one of its competitors."
"Navigating the user console can be challenging, particularly when looking for details like the account ID."
"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."
"Integration into different Python and Jupyter notebooks needs to be improved."
 

Pricing and Cost Advice

"Oracle's prices are too high compared to others in the market."
"I have been using free trial version."
"The solution's price is high and I would rate it an eight out of ten."
"The tool is quite expensive."
"The solution's pricing is affordable."
"I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price."
"Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query."
"Snowflake Analytics is a little more costly than Azure."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
13%
Comms Service Provider
9%
Outsourcing Company
9%
Construction Company
17%
Outsourcing Company
14%
Financial Services Firm
9%
Manufacturing Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise1
Large Enterprise7
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise13
Large Enterprise23
 

Questions from the Community

What needs improvement with Oracle Big Data Appliance?
Areas of Oracle Big Data Appliance that can be improved include the pricing perspective because nowadays they have competition. We have so many technologies that have come to the market for less th...
What is your primary use case for Oracle Big Data Appliance?
The typical use case for Oracle Big Data Appliance, which my clients use, is usually that the customer who has an Oracle application uses it because they can leverage the storage part. I don't need...
What is your experience regarding pricing and costs for Snowflake Analytics?
The pricing for Snowflake Analytics is reasonable, but as I am not part of the management team, I am not certain about our organization's exact costs. Overall, the return on investment for this too...
What needs improvement with Snowflake Analytics?
One improvement Snowflake Analytics could benefit from is in cost, particularly during peak hours. Sometimes, due to its automatic scalability, we think it has scaled up, but it does not always hap...
What is your primary use case for Snowflake Analytics?
I am using Snowflake Analytics because we are already using Snowflake for data engineering and data warehousing tasks, and we are using it for analytics as well as business intelligence reporting. ...
 

Overview

 

Sample Customers

Caixa Bank
Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
Find out what your peers are saying about Snowflake Computing, Google, Databricks and others in Cloud Data Warehouse. Updated: September 2026.
915,341 professionals have used our research since 2012.