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 Oct 26, 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 November 2025, in the Cloud Data Warehouse category, the mindshare of IBM Db2 Warehouse on Cloud is 0.9%, up from 0.4% compared to the previous year. The mindshare of Snowflake is 17.0%, 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.0%
IBM Db2 Warehouse on Cloud0.9%
Other82.1%
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

"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 will be MPP, so performance should improve."
"The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"The speed of data loading and being able to quickly create the environment are most valuable."
"The solution is easy to use."
"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."
"Scaling is a big plus point of Snowflake."
"The solution's computing time is less."
"The syntax is advanced which reduces the time to write code."
 

Cons

"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."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."
"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."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"The design of the product is easily misunderstood."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"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."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
 

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
"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."
"It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
"There is a license needed to use this solution. There are a few licensing options available. They have a pay-as-you-go option, but it is recommended to pay upfront."
"You need to be aware of the bloating costs. It is easy to use, but if you don't use it wisely, then your monthly bill can bloat a lot. You need to be a bit aware of its consumption cost."
"Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
"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."
"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."
"They give a different price for every single company. I don't know if I negotiated that well, but we got the enterprise tier for $3 a credit, and the other two were a dollar-ninety a credit. I suspect we don't have almost zero compute usage, but I know that our annual contract packages are below all of their minimums."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
872,846 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 Enterprise57
 

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: November 2025.
872,846 professionals have used our research since 2012.