SAP Business Warehouse vs Snowflake comparison

SAP and Snowflake Computing are both solutions in the Cloud Data Warehouse category. SAP is ranked #14 with an average rating of 7.0, while Snowflake Computing is ranked #1 with an average rating of 8.1. SAP holds a 2.1% mindshare in CDW, compared to Snowflake Computing’s 17.7% mindshare. Additionally, 89% of SAP users are willing to recommend the solution, compared to 97% of Snowflake Computing users who would recommend it.

SAP Business Warehouse

Read 25 SAP Business Warehouse reviews

730 Views
511 Comparison Views

89% willing to recommend

Snowflake

Read 101 Snowflake reviews

9,251 Views
6,568 Comparison Views

97% willing to recommend

SAP Business Warehouse

Snowflake

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Jul 24, 2025

Snowflake and SAP Business Warehouse are significant contenders in the data warehousing category. Snowflake appears to have the upper hand due to its scalability, performance, and flexible pricing, which is recognized for delivering promising ROI and operational cost reductions.

Features: Snowflake stands out with its scalability, performance, and flexibility, offering diverse data processing capabilities. It is known for efficiently handling massive datasets, powered by its ability to load petabytes of data and perform quick transformations. SAP Business Warehouse is notable for its deep integration with other SAP systems and its strength in structurally managing complex datasets, which is a significant advantage for businesses using a complete SAP suite.

Room for Improvement: Snowflake can enhance its spatial support, streamline Snowpipe auto-ingest features, and improve pricing transparency. Users point out challenges with integration and desire more user-friendly interfaces. SAP Business Warehouse is considered expensive, with suggestions for improving its intuitive design, flexibility, and integration with newer SAP solutions, as well as reducing complexity in setup configurations.

Ease of Deployment and Customer Service: Snowflake utilizes the public cloud, ensuring speedy deployment and solid customer support, although some users mention occasional delays. SAP Business Warehouse operates on private and hybrid clouds, benefiting from robust integration with on-premise systems. Its customer service is praised, but there are concerns about its cost and response speed.

Pricing and ROI: Snowflake has a cost-effective model based on capacity and usage, though some users find it complex and expensive. Its transparency allows scaling according to business needs. In contrast, SAP Business Warehouse is seen as more costly, especially for smaller businesses, with licensing costs tied to company revenue, making it somewhat opaque. Users report a significant ROI from Snowflake related to operational cost reductions, whereas SAP Business Warehouse incurs high consultancy and maintenance costs.

To learn more, read our detailed SAP Business Warehouse vs. Snowflake Report (Updated: September 2025).

Buyer's Guide

SAP Business Warehouse vs. Snowflake

September 2025

Download the complete report

Helped 870,697 peers since 2012

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.3

Number of Reviews

Ranking in other categories

No ranking in other categories

Snowflake

Ranking in Cloud Data Warehouse

1st

Average Rating

8.4

Reviews Sentiment

7.0

Number of Reviews

101

Ranking in other categories

Data Warehouse (1st), AI Synthetic Data (1st)

Mindshare comparison

As of October 2025, in the Cloud Data Warehouse category, the mindshare of SAP Business Warehouse is 2.1%, up from 1.1% compared to the previous year. The mindshare of Snowflake is 17.7%, down from 22.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse Market Share Distribution
Product	Market Share (%)
Snowflake	17.7%
SAP Business Warehouse	2.1%
Other	80.2%

Cloud Data Warehouse

Featured Reviews

Srini-Dhanaraj

Founder & CEO at imfine.club

The solution enables seamless connection, but it is expensive, and the information is one day old

Out-of-the-box reports are very useful. The product provides a seamless connection between the SAP operation system and the data warehouse. It also moves the data from the operating system to the data warehouse in a 3D format. The report generation is easy. It’s a drag-and-drop process. People who want to do a project need not reinvent the wheel. Everything is designed, built, and delivered out of the box. All we have to do is interact with the customers to understand the kind of reports they need and check whether they are already available in the out-of-the-box report. If they are available, we just have to enable them and give the URLs to the customers. The Integration between the SAP operating system and data warehouse is excellent. The UI is good.

Read full review

Snehasish Das

Technology Leader at eTCaaS

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.

Read full review

Quotes from Members

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

Pros

"I like that it integrates to open-source."

"SAP Business Warehouse is a scalable solution."

"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."

"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."

"Predominantly, our company uses SAP Business Warehouse for reporting purposes across various departments, especially for managers to gain a quick understanding of their current standing and make informed decisions."

"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."

"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us."

"With the technical support, the response has been pretty good from the SAP side."

More SAP Business Warehouse pros

"The solution's customer service is good."

"Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."

"The platform's most valuable features include its ability to effectively summarize and manage large datasets, allowing multiple teams to analyze and generate insights."

"Very easy to use and easy to query."

"Scaling is a big plus point of Snowflake."

"The pricing is reasonable and matches the rest of the market."

"The technical support is pretty good, particularly if you are a more technical user."

"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."

More Snowflake pros

Cons

"I get all the information quickly, but it is one day old."

"It's a product that is at the end of life so they will not improve it anymore."

"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."

"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."

"So far, the initial setup process in our company has not been easy enough for us to understand."

"Areas for improvement in SAP Business Warehouse include enhancing scheduling and monitoring tools, as well as improving communication about hidden features to make them more accessible to users."

"SAP Business Warehouse could integrate better with other ETL tools."

"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."

More SAP Business Warehouse cons

"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."

"Snowflake can improve its machine learning and AI capabilities."

"I don't think that the AI tools in Snowflake are good."

"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."

"Getting data out of the tool to third-party applications is difficult."

"We would like to see more security including more masking and more encryption at the database level."

"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."

"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."

More Snowflake cons

Pricing and Cost Advice

"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."

"Overall, the pricing is not fixed and is expensive."

"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."

"I would not recommend it to small-scale companies. The price is too much."

"It's moderately expensive, but definitely has its branding and price value for it."

"The solution is quite expensive."

"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."

"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."

"Snowflake has consumption-based costs; users only pay for storage and computing."

"The pricing for Snowflake is competitive."

"It is not cheap."

"Snowflake is cost-effective."

"It's expensive."

"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."

"The pricing is economical as compared to traditional solutions like Oracle and competitive pricing."

"The price of Snowflake is very reasonable."

More Snowflake pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

870,697 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Manufacturing Company

13%

Retailer

10%

Energy/Utilities Company

Government

Financial Services Firm

19%

Computer Software Company

12%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	7
Midsize Enterprise	4
Large Enterprise	15

By reviewers
Company Size	Count
Small Business	28
Midsize Enterprise	20
Large Enterprise	56

Questions from the Community

What do you like most about SAP Business Warehouse?

Out-of-the-box reports are very useful.

See all answers

What is your experience regarding pricing and costs for SAP Business Warehouse?

The solution is quite expensive. We paid a yearly subscription fee.

See all answers

What needs improvement with SAP Business Warehouse?

Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and bo...

See all answers

What do you like most about Snowflake?

The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.

See all answers

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 ...

See all answers

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 ...

See all answers

Comparisons

Databricks vs SAP Business Warehouse

Compared 31% of the time

BigQuery vs SAP Business Warehouse

Compared 25% of the time

Microsoft Azure Synapse Analytics vs SAP Business Warehouse

Compared 22% of the time

Amazon Redshift vs SAP Business Warehouse

Compared 10% of the time

More SAP Business Warehouse Competitors

Azure Data Factory vs Snowflake

Compared 11% of the time

Teradata vs Snowflake

Compared 8% of the time

Dremio vs Snowflake

Compared 6% of the time

Amazon EMR vs Snowflake

Compared 6% of the time

Microsoft Azure Synapse Analytics vs Snowflake

Compared 6% of the time

More Snowflake Competitors

Product Reports

Buyer's Guide

SAP Business Warehouse

September 2025

Download SAP Business Warehouse product report

Buyer's Guide

Snowflake

September 2025

Download Snowflake product report

Also Known As

No data available

Snowflake Computing, Snowflake Data Cloud

Overview

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

SAP

Snowflake provides a modern data warehousing solution with features designed for seamless integration, scalability, and consumption-based pricing. It handles large datasets efficiently, making it a market leader for businesses migrating to the cloud.

Snowflake offers a flexible architecture that separates storage and compute resources, supporting efficient ETL jobs. Known for scalability and ease of use, it features built-in time zone conversion and robust data sharing capabilities. Its enhanced security, performance, and ability to handle semi-structured data are notable. Users suggest improvements in UI, pricing, on-premises integration, and data science functions, while calling for better transaction performance and machine learning capabilities. Users benefit from effective SQL querying, real-time analytics, and sharing options, supporting comprehensive data analysis with tools like Tableau and Power BI.

What are Snowflake's Key Features?

Scalability: Easily adjusts to handle growing data volumes.
Seamless Integration: Works with a wide range of platforms.
Consumption-Based Costs: Pay only for what you use.
Time Travel: Access historical data effortlessly.
Data Sharing: Secure and efficient sharing of datasets.
Time Zone Conversion: Built-in feature for global operations.
Security: Robust measures to protect sensitive information.
Compute and Storage Separation: Independent scaling for optimal performance.

What Benefits Should You Look for?

Cost Efficiency: Optimized pricing models for minimal waste.
Enhanced Performance: Fast queries and processing times.
Flexibility: Handles both structured and semi-structured data.
Analytics Capabilities: Supports advanced data analysis and reporting.

In industries like finance, healthcare, and retail, Snowflake's flexible data warehousing and analytics capabilities facilitate cloud migration, streamline data storage, and allow organizations to consolidate data from multiple sources for advanced insights and AI-driven strategies. Its integration with analytics tools supports comprehensive data analysis and reporting tasks.

Snowflake Computing

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

Buyer's Guide

SAP Business Warehouse vs. Snowflake

September 2025

Free Report: SAP Business Warehouse vs. Snowflake

Find out what your peers are saying about SAP Business Warehouse vs. Snowflake and other solutions. Updated: September 2025.

DOWNLOAD NOW

870,697 professionals have used our research since 2012.

See our SAP Business Warehouse vs. Snowflake report.

See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.

We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.