IBM Db2 Warehouse on Cloud vs Snowflake vs Teradata comparison

IBM Db2 Warehouse on Cloud

Read 76 Teradata reviews

10,603 Views
2,969 Comparison Views

87% willing to recommend

Snowflake

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between IBM Db2 Warehouse on Cloud, Snowflake, and Teradata based on real PeerSpot user reviews.

Find out what your peers are saying about Snowflake Computing, Microsoft, Google and others in Cloud Data Warehouse.

To learn more, read our detailed Cloud Data Warehouse Report (Updated: August 2025).

Cloud Data Warehouse

Download the complete report

Helped 867,497 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:

Mindshare comparison

As of September 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 23.1% compared to the previous year. The mindshare of Teradata is 8.7%, down from 9.5% 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%
Teradata	8.7%
IBM Db2 Warehouse on Cloud	0.8%
Other	72.8%

Cloud Data Warehouse

Featured Reviews

FarhanFarhan

Database Engineer at Meezan Bank

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…

Transformation in data querying speed with good migration capabilities

Snehasish Das

Technology Leader at eTCaaS

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.

Harnessing advanced parallelism for top performance while embracing cloud trends

RajeshKumar25

Principal Consultant & Director at Quensulting

Teradata is primarily used for data warehousing across all customers. My clients have built-in applications that use Teradata, and their use varies from customer to customer, depending on the industry and database size. The primary function is as an OLAP analytical ecosystem Scalability is…

More Snowflake pricing and cost advice

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 will be MPP, so performance should improve."

"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 stable when there is support from IBM."

"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."

"The solution is easy to use."

"The solution's computing time is less."

"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."

"It was relatively easy to use, and it was easy for people to convert to it."

"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."

"Snowflake's most valuable features are data enrichment and flattening."

"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."

More Snowflake pros

"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."

"It is very stable. It's 100% uptime. Speed and resilience are one of the greatest features of this product. In almost twenty years we've never had downtime, except for outages for patches and upgrades. We've never had a system failure in twenty years."

"Teradata's capabilities enhance data management efficiency, support scalability, and contribute to faster query performance."

"The flexibility in design is very good."

"It has massive parallel processing ability to do large amounts of concurrent querying."

"Teradata is a great, industry-leading data warehousing product that has MPP architecture."

"The key advantages are Performance when processing Terabytes of data and scalability."

"The product's scalability is great. Scalability-wise, I rate the solution a ten out of ten."

More Teradata pros

Cons

"There are some limitations in adding data files to table spaces, and improvements are needed for regional support."

"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."

"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."

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

"I think that Snowflake could improve its user interface. The current one is not interactive."

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

"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."

"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."

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

"I am still in the learning stage. It has good security, but it can always be more secure."

"Improvement is needed in integrating external tools, such as data catalogs, which can be complicated due to differing formats and usage across departments."

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

More Snowflake cons

"Stability-wise, we have had some issues with automation and the ability to handle large datasets."

"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."

"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."

"It could use some more advanced analytics relating to structured and semi-structured data."

"It needs a teaching web site with more training on third-party tools used for BI."

"Teradata hardly supports unstructured data or semi-structured data"

"From my perspective, it would be good if they gave better ITIN/R plugins to use the data for AI modeling, or data science modeling. We can do it now; however, it could be more elegant in terms of interfacing."

"I would like to see an improved Knowledge Base on the web."

More Teradata cons

Pricing and Cost Advice

"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."

"It is hard to say because we're usually engaged in the transition as opposed to the long term. Their storage costs are easily within pennies of what AWS S3 would normally cost. Most of the clients I've been working with are in the financial sector, and they're relatively small. I would put them in an SMB connection. The first thing we have to bring up for people is that they're going to build this. They shouldn't store their data in S3. They should pipeline directly into Snowflake and use it on their storage. So, the cost is a big issue because these are small to medium size companies, and that is the biggest thing we had to price point for them."

"The price for the solution's license depends on the use cases."

"The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year."

"The price of the solution is reasonable."

"Snowflake is cost-effective."

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

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

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

"Teradata's licensing is on the expensive side."

"It's a very expensive product."

"The cost of running Teradata is quite high, but you get a good return on investment."

"We are looking for a more flexible cost model for the next version that we use, whether it be cloud or on-premise."

"Teradata is a very expensive solution."

"When looking into implementing this product, pricing is the main issue followed by technical expertise."

"The solution requires a license."

"It is still a very expensive solution. While I very much like the pure technological supremacy of the software itself, I believe Teradata as a company needs to become more affordable. They are already losing the market to more flexible or cheaper competitors."

More Teradata 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

867,497 professionals have used our research since 2012.

Comparison Review

it_user232068

Senior Data Architect at a pharma/biotech company with 1,001-5,000 employees

Aug 5, 2015

Netezza vs. Teradata

Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…

What advice do you have for others considering IBM Db2 Warehouse on Cloud?

Top Industries

By visitors reading reviews

No data available

Financial Services Firm

20%

Computer Software Company

13%

Manufacturing Company

Healthcare Company

Financial Services Firm

25%

Computer Software Company

10%

Manufacturing Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	4
Large Enterprise	3

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

By reviewers
Company Size	Count
Small Business	25
Midsize Enterprise	12
Large Enterprise	49

Questions from the Community

Organizations of all sizes, especially those who are in need of powerful and elastic cloud data warehouse solutions t...

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

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

Comparing Teradata and Oracle Database, which product do you think is better and why?

I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may d...

Which companies use Teradata and who is it most suitable for?

Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if ...

Is Teradata a difficult solution to work with?

Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if ...

IBM Netezza Performance Server vs IBM Db2 Warehouse on Cloud

Comparisons

Compared 36% of the time

Amazon Redshift vs IBM Db2 Warehouse on Cloud

Compared 34% of the time

Oracle Exadata vs IBM Db2 Warehouse on Cloud

Compared 30% of the time

More IBM Db2 Warehouse on Cloud Competitors

Azure Data Factory vs Snowflake

Compared 12% of the time

Dremio vs Snowflake

Compared 7% of the time

Amazon EMR vs Snowflake

Compared 6% of the time

SAP BW4HANA vs Snowflake

Compared 6% of the time

AWS Lake Formation vs Snowflake

Compared 6% of the time

More Snowflake Competitors

Oracle Exadata vs Teradata

Compared 12% of the time

IBM Db2 Database vs Teradata

Compared 7% of the time

SQL Server vs Teradata

Compared 7% of the time

OpenText Analytics Database (Vertica) vs Teradata

Compared 6% of the time

Amazon Redshift vs Teradata

Compared 6% of the time

More Teradata Competitors

Product Reports

Cloud Data Warehouse

Download IBM Db2 Warehouse on Cloud product report

Snowflake

Download Snowflake product report

Download Teradata product report

Also Known As

IBM dashDB

Snowflake Computing, Snowflake Data Cloud

IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture

Overview

IBM dashDB family offers private and public cloud database solutions for transactional and analytic workloads, with IBM fully managed or client managed options with a Common SQL engine across all deployment options.

IBM

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

Teradata is a scalable data analytics platform designed to meet enterprise demands for large-scale data management and processing, focusing on performance, scalability, and security for complex query executions.

As a leading data warehousing solution, Teradata integrates advanced analytics enabling organizations to derive insights from massive datasets. It supports high-volume data workloads with its architecture optimized for analytical queries. Users benefit from its robust scalability, allowing seamless expansion as data grows. Teradata's SQL engine is compatible with a wide range of data types, ensuring flexibility in data analysis. With advanced security measures, it protects sensitive data across various environments, providing peace of mind to users handling critical information.

What are the most important features of Teradata?

Linear Scalability: Easily expands data processing capabilities to handle increasing data loads without performance degradation.
Advanced Analytics: Supports complex analytical operations integrating machine learning and AI for predictive insights.
SQL Compatibility: Offers a comprehensive SQL interface that supports complex queries across diverse data types.
Data Security: Implements rigorous security protocols to protect data integrity and confidentiality.

What benefits and ROI should users look for?

Improved Decision-Making: Derive actionable insights quickly for strategic business decisions.
Cost Efficiency: Optimized resource usage reduces operational costs associated with data processing.
Increased Productivity: Streamlined data operations save time, allowing teams to focus on analysis.
Enhanced Scalability: Seamless growth without significant additional investment as data volumes increase.

Teradata is widely used in industries like finance, telecommunications, and healthcare, where data-driven decisions are critical. Companies leverage its robust analytics capabilities to enhance customer experiences, streamline operations, and ensure compliance with regulatory requirements. In these sectors, quick access to data insights can significantly impact competitive advantage.