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

Oracle Big Data Appliance vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jul 24, 2025

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
Ranking in Data Warehouse
13th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
6
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.0
Number of Reviews
101
Ranking in other categories
Cloud Data Warehouse (1st), AI Synthetic Data (1st)
 

Mindshare comparison

As of August 2025, in the Data Warehouse category, the mindshare of Oracle Big Data Appliance is 1.4%, up from 1.1% compared to the previous year. The mindshare of Snowflake is 14.0%, down from 19.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

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.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

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."
"Can be leveraged with respect to better performance, auto tuning and competition."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"It's user-friendly. It's SQL-driven. The fact that business can also go to this application and query because they know SQL is the biggest factor."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"The solution's computing time is less."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
 

Cons

"The product should be simplified for the average user."
"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."
"Sometimes it can be tricky to manage multiple environments if you're purely using Snowflake as your scripting and pipeline environment."
"Improvement is needed in integrating external tools, such as data catalogs, which can be complicated due to differing formats and usage across departments."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"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."
"It's difficult to know how to size everything correctly."
"If you go with one cloud provider, you can't switch."
"The cost is a bit high."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
 

Pricing and Cost Advice

"Oracle's prices are too high compared to others in the market."
"The price of Snowflake is quite reasonable."
"It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee. We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data."
"Pricing is based on usage. It is the most expensive of our data tools."
"Snowflake’s pricing is transparent. It is one of the cheapest cloud database warehouse providers. The tool follows a credit cost model. Everything on Snowflake is charged on the basis of credits. The credits depend on the cloud region and the public cloud provider that we use. Hence, the cost per credit will be different for AWS in Frankfurt and AWS in India. I think North Virginia is the cheapest region in terms of cost per credit. You will be consuming around 16 credits for large data warehouses."
"Snowflake is a cost-effective solution."
"On average, with the number of queries that we run, we pay approximately $200 USD per month."
"Pricing can be confusing for customers."
"We use Snowflake pretty heavily. We pay a significant amount of money for the tool. I'd say we pay $300k to $400K every year."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
865,140 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
21%
Computer Software Company
12%
Manufacturing Company
8%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Ask a question
Earn 20 points
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
It is complicated to understand how requests impact warehouse size. Unlike competitors such as Microsoft and Databricks ( /products/databricks-reviews ), Snowflake lacks transparency in estimating ...
What needs improvement with Snowflake?
Pricing is quite high for Snowflake Data Cloud, which is an area that could be improved. Snowflake Data Cloud is still beneficial to use, but only if you can afford it. It can be cost-effective if ...
 

Also Known As

No data available
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Caixa Bank
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Oracle Big Data Appliance vs. Snowflake and other solutions. Updated: August 2025.
865,140 professionals have used our research since 2012.