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

SAP Business Warehouse vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Feb 1, 2026

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

SAP Business Warehouse
Ranking in Cloud Data Warehouse
14th
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
26
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Cloud Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
104
Ranking in other categories
Data Warehouse (1st), AI Synthetic Data (2nd), Database Management Systems (DBMS) (7th), AI Software Development (9th)
 

Mindshare comparison

As of February 2026, in the Cloud Data Warehouse category, the mindshare of SAP Business Warehouse is 2.3%, up from 1.0% compared to the previous year. The mindshare of Snowflake is 15.9%, down from 22.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
Snowflake15.9%
SAP Business Warehouse2.3%
Other81.8%
Cloud Data Warehouse
 

Featured Reviews

VishnuReddy2 - PeerSpot reviewer
Consulting Enterprise Architect at R2V2.ai
Have encountered complexity with programming language while working on large-scale data integration and have experienced improved governance and reporting
The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult. Regarding the future of SAP Business Warehouse, I would to see added features that simplify the product very well now. They are coming up with a terminology called SAP BDC where they are consolidating their tools, SAP Data Sphere for integration and SAP BW for the ETL and warehousing parts, and SAP Analytics Cloud. They are packaging these three features and calling it Business Data Cloud; they are fully coming on the cloud. We have to wait and watch; they have been speaking about BW/4HANA for quite some time now, but the customers or clients I work with are not finding great interest and it was seen as a candidate for evaluation. I have seen people looking at the latest technologies who are already on cloud who started building from scratch on cloud, such as Snowflake or Databricks, which can process very huge amounts of data and also address unstructured data, where SAP lags behind in cases where there is a need to bring in unstructured data. I have worked with SAP Data Intelligence, which earlier used to be called SAP Data Hub. The unstructured data is not greatly handled in SAP at this point in time.
SunilPatil1 - PeerSpot reviewer
Asset Builder at Genpact - Headstrong
Have prioritized security while managing multi-agent data migration and cloud adoption
We utilize Time Travel with Snowflake because this is a very useful feature. Everyone finds it crucial because in conventional data platforms, it's very difficult to handle these kinds of things. This feature is essential, though I don't have the use cases currently; it is just there for implementation. Regarding Snowflake's automated scaling and suspension features, this auto-scaling is very significant. We had a comparison with Databricks and Snowflake a few months back, and this auto-scaling takes an edge within Snowflake; that's what our observation reflects.

Quotes from Members

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

Pros

"With the technical support, the response has been pretty good from the SAP side."
"I like that it integrates to open-source."
"The product is very stable."
"The warehouse is the solution's most valuable feature."
"In terms of stability, comparatively, the solution is quite stable."
"The most useful feature has been he ability to feed data into multiple systems in various formats."
"The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs."
"Out-of-the-box reports are very useful."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"It is quite easy to manage."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"The most valuable feature of Snowflake is it's an all-in-one data warehousing solution."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"The most valuable features of Snowflake are its performance and power."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
 

Cons

"It's a product that is at the end of life so they will not improve it anymore."
"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."
"One of our requirements is the ability to easily get answers regarding trends and exceptions. In BW, it is not that easy to get such information. I expect better trend and exception detection, better pattern detection."
"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."
"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."
"A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution."
"More integration with Microsoft Office products (not just Excel) would be helpful."
"Integration with SAP Business Warehouse's ETL tools is not straightforward."
"Support needs improvement, as it can take several days before you get some initial support."
"Currently there isn't end-to-end or B2B sharing of data."
"The data sharing capabilities across business units within the organization should be better."
"The solution needs more connectors."
"I can only access Snowflake from the web. It would be better if we could have an app that we can install locally on our laptops to connect to the server without needing to go to the web page. Apart from that, it's hard to point out any limitations in the tool."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"There is a scope for improvement. They don't currently support integration with some of the Azure and AWS native services. It would be good if they can enhance their product to integrate with these services."
"Availability is a problem."
 

Pricing and Cost Advice

"I would not recommend it to small-scale companies. The price is too much."
"The solution is quite expensive."
"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."
"It's moderately expensive, but definitely has its branding and price value for it."
"Overall, the pricing is not fixed and is expensive."
"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."
"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."
"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."
"You pay based on the data that you are storing in the data warehouse and there are no maintenance costs."
"Comparing Snowflake to on-prem options such as Oracle or SAP, it seemed more cost-effective."
"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."
"It's expensive."
"I have not been billed yet, but it should be less. I'm still running the trial version, but it seems to be less than Databricks."
"Snowflake is a cost-effective solution."
"Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
"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 Cloud Data Warehouse solutions are best for your needs.
882,333 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Manufacturing Company
11%
Retailer
9%
Energy/Utilities Company
9%
Marketing Services Firm
8%
Financial Services Firm
20%
Computer Software Company
9%
Manufacturing Company
9%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business8
Midsize Enterprise4
Large Enterprise15
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise20
Large Enterprise58
 

Questions from the Community

What is your experience regarding pricing and costs for SAP Business Warehouse?
The pricing for SAP Business Warehouse is on the expensive side. I am not sure about the current costing model as such. In my experience on cloud, I did not use BW HANA Cloud. I used the cloud prod...
What needs improvement with SAP Business Warehouse?
The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult. Regarding the future of SAP Business Warehou...
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?
Snowflake is currently stable, but it can be improved further. They have a couple of information schemas that can track account usage. If more connectors were brought in and more visibility feature...
What is your primary use case for Snowflake?
I have used Snowflake for an end-to-end data solutioning as a warehouse, including all its capabilities such as ingestion and any implementations that were needed.
 

Also Known As

No data available
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: January 2026.
882,333 professionals have used our research since 2012.