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

IBM Db2 Warehouse 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

IBM Db2 Warehouse
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
12
Ranking in other categories
Data Warehouse (11th)
Snowflake Analytics
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
40
Ranking in other categories
Web Analytics (1st), Cloud Data Warehouse (9th)
 

Featured Reviews

Sherpard  Muzuva - PeerSpot reviewer
Advanced features enhance business intelligence, but complex management calls for improved user guidance
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more user-friendly and easier to master. They should implement a more comprehensive graphical user interface with additional features. For instance, when users encounter problems, the system should provide better guidelines and troubleshooting directions, except for hardware-related issues. They need to implement tools that would help users perform basic troubleshooting rather than solely relying on support. Other databases have features where users can investigate specific issues using error codes. From my experience, many minor issues could be resolved before escalating to support.
Paresh_Nayak - PeerSpot reviewer
Enables data-driven decision-making with robust features and effective scalability
The internal design engine and the columnar database are particularly valuable. These features reduce input and output memory, which is crucial in handling large data sets. The solution fulfills the business requirement for scaling and analytics. Snowflake Analytics supports data security with a single sign-on feature and complies with framework regulations, which is highly beneficial.

Quotes from Members

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

Pros

"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"The analytics engine is not bad at forecasting predictions."
"It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."
"The solution is stable."
"It can scale effectively as long as resources are available."
"The most valuable features of IBM Db2 Warehouse include its availability, easy integration, ability to deal with a large size of data, excellent performance with no delays, powerful security mechanisms, and effective support."
"IBM Db2 Warehouse is more resilient when dealing with business intelligence applications."
"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."
"Its performance speed is very good."
"It ensures the optimization of the application development while maintaining the user-friendly nature of its UI."
"Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options."
"I am impressed with the product's data-sharing feature."
"Snowflake Analytics' predictive analytics elements, which incorporate AI, are good and easy to integrate."
"One of the distinctive features of Snowflake is its ability to handle large datasets efficiently."
"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."
 

Cons

"The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."
"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"There should be more material available for training and training should be free."
"IBM Db2 Warehouse needs to improve its interface."
"Lacks sufficient documentation and particularly in Spanish."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"The primary challenges customers face with IBM Db2 Warehouse are related to its complexity in usage. It requires highly skilled professionals who understand Db2, and both training and support are challenging to obtain."
"The platform's data governance space needs more capability."
"One notable absence in Snowflake's offerings is an on-premises solution."
"Navigating the user console can be challenging, particularly when looking for details like the account ID."
"Integration into different Python and Jupyter notebooks needs to be improved."
"The UI must be improved."
"The product's cost is an area of concern where improvements are required."
"End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization."
"Snowflake could improve in the areas of advanced machine learning AML and generative AI."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"The solution's price is high and I would rate it an eight out of ten."
"The pricing is on the higher side."
"The product's pricing is subjective."
"Snowflake Analytics is a little more costly than Azure."
"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."
"The tool is quite expensive."
"I rate the product price a seven on a scale of one to ten, where one is low price, and ten is high price."
"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."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
28%
Government
10%
Manufacturing Company
9%
Computer Software Company
8%
Computer Software Company
15%
Financial Services Firm
10%
Retailer
10%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Db2 Warehouse?
The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
What is your experience regarding pricing and costs for IBM Db2 Warehouse?
The pricing for medium and large environments is almost the same as Oracle. I rate the pricing as six out of ten.
What needs improvement with IBM Db2 Warehouse?
While my experience with IBM Db2 Warehouse is somewhat limited, when compared to other databases such as Oracle, there are areas for improvement. They need to enhance the database to make it more u...
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?
The advantages of Snowflake Analytics outweigh the disadvantages. However, if it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it wo...
 

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse
No data available
 

Overview

 

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited
Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
Find out what your peers are saying about IBM Db2 Warehouse vs. Snowflake Analytics and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.