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

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

"It is stable when there is support from IBM."

"I like the idea that you can assign roles and responsibilities, limiting access to data."

"The platform's most valuable features include its ability to effectively summarize and manage large datasets, allowing multiple teams to analyze and generate insights."

"It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."

"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."

"For us, the virtual warehousing is likely the most valuable aspect."

"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."

"The speed of data loading and being able to quickly create the environment are most valuable."

"I like Snowflake's data exchange capabilities. It can exchange data with downstream systems and other vendor partners as well."

More Snowflake pros

"It is a stable program."

"Teradata's best feature is its speed with historical data."

"It has increased the speed of reporting."

"The ability to handle machine data parallel processing is the most valuable feature of Teradata."

"Teradata's most valuable feature is that it's easy to use."

"The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems."

"The most valuable feature is the ease of uploading data from multiple sources."

"Auto-partitioning and indexing, and resource allocation on the fly are key features."

More Teradata pros

Cons

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

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

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

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

"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."

"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."

"The data sharing capabilities across business units within the organization should be better."

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

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

"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."

"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."

"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."

More Snowflake cons

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

"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."

"There is a need to improve performance in high transaction processes, as well as the reporting system."

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

"Data synchronization to the DR site."

"I would like more security and speed."

"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."

"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."

More Teradata cons

Pricing and Cost Advice

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

"Snowflake is a cost-effective solution."

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

"The solution is costly, making it unsuitable for midsize organizations due to its price."

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

"It is pay-as-you-go. Its cost is in the medium range."

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

"Snowflake is cost-effective."

"Teradata used to be expensive, but they have been lowering their prices."

"The tool costs about 30,000 euros a month, while Azure Synapse SQL only costs 10,000."

"Teradata is not cheap, but you get what you pay for."

"Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."

"Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."

"The price needs to be more competitive as Hadoop, Redshift, Snowflake, etc are constantly making way into EDW space."

"I would advise others to look into migration and setup as a fixed price and incorporate a SaaS option for other Teradata services."

"The product cost is high for what the client gets. There may be more cost-effective solutions for small and medium-sized organizations."

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.