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

Featured Reviews

Mohammed Hamad - PeerSpot reviewer
Provides clean, centralized data
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. Oracle could also improve Big Data Appliance by having one technology on their stack and working on it instead of continually changing the name or technologies or features. In addition, they could have a program to enable their partners to use this technology because right now, I have to have an expert to use the AI elements.
Garima Goel - PeerSpot reviewer
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

"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"This is a comprehensive solution that is easy to deploy."
"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 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."
"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."
"One advantage is that installation is unnecessary since it's cloud-based. You subscribe to a Snowflake instance, configure it, and start using it. It's very user-friendly and allows you to scale up or down based on usage."
"It is quite a convenient tool."
"It's cloud-based technology, so users can spin it up a lot faster"
"The most important feature is the warehouse functionality."
"Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options."
"Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake."
 

Cons

"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."
"The product should be simplified for the average user."
"The solution needs to consider including some updates in the future."
"One notable absence in Snowflake's offerings is an on-premises solution."
"Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake."
"Machine learning should be improved."
"The platform could work easier for AI implementation compared to one of its competitors."
"There are issues while loading data from Snowflake Analytics to the Power BI reporting."
"The tool should support EIM use cases. I guess the product is already working on it. I look forward to seeing inbuilt AI generative tools in the solution's future releases. The tool's price can be a little lower. The solution's on-premises support is also very limited. We have to rely on other support services to deploy it on-premises."
"However, if it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better."
 

Pricing and Cost Advice

"Oracle's prices are too high compared to others in the market."
"It is not overly expensive. I would rate the pricing a six out of ten, with ten being expensive."
"I have been using free trial version."
"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."
"Snowflake Analytics is not an expensive solution, and its pricing is average."
"The pricing is on the higher side."
"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."
"The tool is quite expensive."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
869,566 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Computer Software Company
16%
Retailer
9%
Financial Services Firm
9%
Government
6%
 

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 Business10
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?
There are some minor issues encountered with Snowflake Analytics, such as problems when working with identity or row number generating different results or issues with referential integrity, which ...
 

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: September 2025.
869,566 professionals have used our research since 2012.