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

Oracle Big Data Appliance vs Snowflake Analytics comparison

 

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 (14th)
Snowflake Analytics
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
43
Ranking in other categories
Web Analytics (2nd), Cloud Data Warehouse (10th)
 

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.
Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Have created secure cloud-based data lakes and improved real-time data processing using integrated AI features
There are many capabilities which Snowflake Analytics offers that I find valuable, such as the storage and compute engine that allows working with any cloud system such as AWS or Azure, alongside its efficiencies in storage computation and cost-effectiveness, which saves money compared to on-premise systems. We also have features such as pre-cached results, Time Travel, and fail-safe, which are very useful for restoring data if deleted accidentally, and the streams and data pipes that facilitate real-time ingestion are great features as well. Snowflake Analytics offers multiple new connectors, allowing me to connect it with Kafka, and with Snowpark, I can work with any programming language such as Python, Java, or Scala for data processing and analysis. The data sharing feature offered by Snowflake Analytics is good because it allows sharing specific sets of data to end customers or users from different Snowflake Analytics accounts without exposing the entire dataset for data security reasons. Snowflake Analytics' support for machine learning models and real-time insights has enhanced significantly. Originally, it wasn't strong in AI/ML, but now it has multiple models and forecasting capabilities, providing good competition to tools such as Databricks and Spark. In BI, I have worked majorly with Microsoft Power BI, and the integration with Snowflake Analytics is very easy. The way we integrate Snowflake Analytics with other on-premise systems just requires the warehouse details, username, passwords, and the account name, along with multiple options such as client ID and credentials for logging in and creating a session. The end-to-end encryption provided by Snowflake Analytics is very important because, in my previous firm, working in finance and investment management, data encryption is necessary due to the sensitive nature of customer data and the involvement of people's money. It's crucial to have encryption in transit and at rest, along with data masking features which Snowflake Analytics offers.

Quotes from Members

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

Pros

"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"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."
"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."
"It's not necessary to use a physical server."
"The computational power of Snowflake is very good."
"Snowflake Analytics has a bright future and is capturing the market across various domains such as life sciences, BFSI, and supply chain."
"The most valuable features of Snowflake for our data analytics are its time travel capability, allowing easy data recovery, and its automatic optimization of partitioning and clustering."
"Scalability-wise, I rate the solution a ten out of ten."
"The platform not only provides ease of use but also stands out for its speedy execution, conveying a sense of robustness and reliability that I find appealing."
"The advanced features like time travel, zero copy cloning and scalability have been most useful. Snowflake requires zero maintenance for Data Warehousing on the cloud system."
"Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company."
 

Cons

"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"The product should be simplified for the average user."
"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."
"The technical support is not very good."
"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."
"Improvements are needed in importing and exporting large datasets to and from reporting tools."
"The UI could be more user-friendly."
"Snowflake Analytics should probably have more built-in tools for master data management."
"However, if it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better."
"AIML-based SQL prompt and query generation could be an area for enhancement."
 

Pricing and Cost Advice

"Oracle's prices are too high compared to others in the market."
"The pricing is on the higher side."
"Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query."
"It's not costly if you configure it properly to ensure optimal performance. People don't configure it properly, which is why costs go up."
"The cost of Snowflake Analytics is low, any small organization can use it."
"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."
"Snowflake Analytics is not an expensive solution, and its pricing is average."
"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."
"Snowflake Analytics is a little more costly than Azure."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
881,114 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Computer Software Company
14%
Financial Services Firm
8%
Healthcare Company
7%
Retailer
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business1
Midsize Enterprise1
Large Enterprise6
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise12
Large Enterprise21
 

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?
Snowflake Analytics is quite economical. It does not appear to incur significant extra expenses beyond the solution's initial cost. However, a complete pricing analysis is still in progress.
What needs improvement with Snowflake Analytics?
In my opinion, Snowflake Analytics can be improved by introducing more features, such as additional integration options. I remember using Snowflake Pro, which allows exporting direct data into the ...
 

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 Oracle Big Data Appliance vs. Snowflake Analytics and other solutions. Updated: December 2025.
881,114 professionals have used our research since 2012.