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

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

IBM Db2 Warehouse on Cloud
Ranking in Cloud Data Warehouse
15th
Average Rating
7.6
Reviews Sentiment
6.3
Number of Reviews
7
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 IBM Db2 Warehouse on Cloud is 0.8%, up from 0.3% 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
ProductMarket Share (%)
Snowflake17.7%
IBM Db2 Warehouse on Cloud0.8%
Other81.5%
Cloud Data Warehouse
 

Featured Reviews

FM
Enhancing analytics with seamless data dumping and reliable support
Our primary use case is data storage and analytics The organization has decided to purchase a full stack solution from IBM due to positive responses, which helped them upgrade from the previous version. The data dumping into the raw zone and the feature of BigQuery is quite attractive. There…
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

"It will be MPP, so performance should improve."
"The performance is okay as long as the volume of queries is not too high."
"It is stable when there is support from IBM."
"The way that it scales will help a lot of customers that are stuck with Netezza boxes that can't grow any larger.​"
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"The product's most important feature is unloading data to S3."
"The solution speeds up the process of onboarding."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"Snowflake has three great features: Snowpiping is proving to be very valuable, Time Travel is excellent, and Snowpipes are another great functionality the solution has made available."
"Everything is automatic, and I don't have to do any maintenance."
"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."
 

Cons

"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Right now, we are implementing on ESX VMware 6.0. Support for this platform is poor. Also, one of the backup/recovery options is broken and IBM is not addressing the issue."
"It would be helpful if Snowflake could create good reports instead of using Power BI reports."
"If you go with one cloud provider, you can't switch."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"More data governance and access control features would be a welcome addition."
"It doesn't enforce typical relational database constraints. Quite expensive."
 

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
"Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
"Part of the problem with the pricing is that it is very difficult for businesses to get an idea of how expensive it might be until they actually start using Snowflake."
"I believe that pricing is reasonable for this solution."
"The solution is costly, making it unsuitable for midsize organizations due to its price."
"The tool's pricing is based on the number of queries you want on your database. The cost is small. To get the tool's pricing, you can do the math based on the cost per query, which is $0.002. If you're running your queries frequently, your charges will be higher than running fewer queries."
"Snowflake is expensive, but when I consider what we get for that price, it's fair. I rate the solution three out of five for affordability, right in the middle."
"Snowflake is cost-effective."
"We're based on credits. So, we're paying four and a half dollars of credit. There are no additional costs. I would rate it a two out of five in terms of pricing."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
868,759 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
By reviewers
Company SizeCount
Small Business28
Midsize Enterprise20
Large Enterprise56
 

Questions from the Community

What advice do you have for others considering IBM Db2 Warehouse on Cloud?
Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions that can help administrators maximize the efficiency of their data-based operatio...
What needs improvement with IBM Db2 Warehouse on Cloud?
There are some limitations in adding data files to table spaces, and improvements are needed for regional support.
What is your primary use case for IBM Db2 Warehouse on Cloud?
Our primary use case is data storage and analytics.
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

IBM dashDB
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Copenhagen Business School, BPM Northwest, GameStop
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about IBM Db2 Warehouse on Cloud vs. Snowflake and other solutions. Updated: September 2025.
868,759 professionals have used our research since 2012.