No more typing reviews! Try our Samantha, our new voice AI agent.

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

IBM Db2 Warehouse
Ranking in Data Warehouse
13th
Average Rating
7.8
Reviews Sentiment
6.1
Number of Reviews
12
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
106
Ranking in other categories
Cloud Data Warehouse (1st), AI Synthetic Data (1st), Database Management Systems (DBMS) (3rd), AI Software Development (6th)
 

Mindshare comparison

As of August 2026, in the Data Warehouse category, the mindshare of IBM Db2 Warehouse is 2.9%, up from 2.4% compared to the previous year. The mindshare of Snowflake is 9.4%, down from 13.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Mindshare Distribution
ProductMindshare (%)
Snowflake9.4%
IBM Db2 Warehouse2.9%
Other87.7%
Data Warehouse
 

Featured Reviews

Sherpard  Muzuva - PeerSpot reviewer
Senior Technical Manager at SYSTEMS INTEGRATED LTD (SYMPHONY)
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.
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

"If you have good people designing how the data is stored, it's a marvelous tool."
"The solution is stable."
"The solution works with big data, so it's pretty scalable."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"It can scale effectively as long as resources are available."
"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."
"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."
"My advice for anybody who is considering Snowflake is that it is a really good product, especially if you are having issues with Big Data."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"Its speed and performance were the most valuable, and the easy configuration of Snowflake in any cloud was also a benefit."
"The features I found most valuable with this solution are sharing options and built-in time zone conversion."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"The most valuable features of Snowflake are its performance and power."
"The most valuable aspect of Snowflake is its scalability."
"They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises."
 

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."
"The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"There should be more material available for training and training should be free."
"I previously used DataStage, which I think is better than InfoSphere Warehouse."
"Responding to support tickets takes a lot of time. It can range from two to four days, even for critical issues."
"It takes a long time to have a new version or release, similar to Oracle."
"They have a new console, but I couldn't figure out anything in the new console."
"They need to incorporate some basic OLAP capabilities in the backend or at the database level. Currently, it is purely a database. They call it purely a data warehouse for the cloud. Currently, just like any database, we have to calculate all the KPIs in the front-end tools. The same KPIs again need to be calculated in Snowflake. It would be very helpful if they can include some OLAP features. This will bring efficiency because we will be able to create the KPIs within Snowflake itself and then publish them to multiple front-end tools. We won't have to recreate the same in each project. There should be the ability to automate raised queries, which is currently not possible. There should also be something for Exception Aggregation and things like that."
"Currently there isn't end-to-end or B2B sharing of data."
"Snowflake needs transparency over costs and pricing."
"It is not that friendly with relational structures."
"Its price should be improved. On the cost-side, it is more expensive than others."
"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."
"I see room for improvement when it comes to credit performance. The other thing I'd like to be improved is the warehouse facility."
 

Pricing and Cost Advice

"In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
"The solution is costly, making it unsuitable for midsize organizations due to its price."
"The pricing is economical as compared to traditional solutions like Oracle and competitive pricing."
"We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
"Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
"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."
"Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
"Pricing is based on usage. It is the most expensive of our data tools."
"I am not much aware of the price, but based on what I have analyzed so far, its cost is reasonable as compared to on-prem data warehouse solutions. It provides a great deal for production."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
908,834 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
24%
Construction Company
11%
Comms Service Provider
6%
Manufacturing Company
6%
Financial Services Firm
19%
Manufacturing Company
11%
Outsourcing Company
7%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business5
Midsize Enterprise3
Large Enterprise5
By reviewers
Company SizeCount
Small Business30
Midsize Enterprise20
Large Enterprise61
 

Questions from the Community

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 primary use case for IBM Db2 Warehouse?
The main advantages of IBM Db2 Warehouse become apparent when dealing with business intelligence applications. I worked with it when it was installed for one of our customers, a utilities company, ...
What is your experience regarding pricing and costs for Snowflake?
I am not the person who manages pricing, setup cost, and licensing. Our team is not limited in pricing. The only experience we have had in terms of running and reprocessing a large number of histor...
What needs improvement with Snowflake?
One main area for improvement in Snowflake is cost visibility and optimization; while it's flexible and scalable, costs can increase quickly if warehouses are left running unnecessarily or workload...
What is your primary use case for Snowflake?
As a Data Engineer, I primarily use Snowflake for data warehousing tasks as well as ETL processing, and sometimes I also use it for data sharing. I personally find Snowflake better than other tools...
 

Also Known As

InfoSphere Warehouse, IBM InfoSphere Warehouse
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Alameda County Social Services Agency, Sui Southern Gas Company Limited
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about IBM Db2 Warehouse vs. Snowflake and other solutions. Updated: August 2026.
908,834 professionals have used our research since 2012.