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

BigQuery vs IBM Db2 Warehouse on Cloud comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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

BigQuery
Ranking in Cloud Data Warehouse
3rd
Average Rating
8.2
Reviews Sentiment
7.2
Number of Reviews
41
Ranking in other categories
No ranking in other categories
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
 

Mindshare comparison

As of October 2025, in the Cloud Data Warehouse category, the mindshare of BigQuery is 8.0%, up from 7.8% compared to the previous year. The mindshare of IBM Db2 Warehouse on Cloud is 0.8%, up from 0.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Market Share Distribution
ProductMarket Share (%)
BigQuery8.0%
IBM Db2 Warehouse on Cloud0.8%
Other91.2%
Cloud Data Warehouse
 

Featured Reviews

Luís Silva - PeerSpot reviewer
Handles large data sets efficiently and offers flexible data management capabilities
The features I find most valuable in this solution are the ability to run and handle large data sets in a very efficient way with multiple types of data, relational as SQL data. It is kind of difficult to explain, but structured data and the ability to handle large data sets are key features. The data integration capabilities in BigQuery were, in fact, an issue at the beginning. There are two types of integrations. As long as integration is within Google, it is pretty simple. When you start to try to connect external clients to that data, it becomes more complex. It is not related to BigQuery, it is related to Google security model, which is not easy to manage. I would not call it an integration issue of BigQuery, I would call it an integration issue of Google security model.
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…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The initial setup is straightforward."
"The query tool is scalable and allows for petabytes of data."
"This solution is highly scalable."
"BigQuery excels at data analysis. It processes vast amounts of information using its advanced architecture and sophisticated querying capabilities, making it crucial for critical insights and safe for handling sensitive data."
"BigQuery allows for very fast access, and it is efficient in handling large datasets compared to other SQL databases."
"BigQuery processes a substantial amount of data, whether in gigabytes or terabytes, swiftly producing desired data within one or two minutes."
"The solution is very useful nowadays for keeping a huge number of records."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"It is stable when there is support from IBM."
"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.​"
"The performance is okay as long as the volume of queries is not too high."
 

Cons

"It would be beneficial if BigQuery could be made more affordable."
"For greater flexibility and ease of use, it would be beneficial if BigQuery offered more third-party add-ons and connectors, particularly for databases that don't have built-in integration options."
"When I open many of the Google Cloud products, I am in an environment that I do not feel familiar with; it is a little overwhelming."
"It can be slower and more problematic compared to other platforms such as Snowflake."
"An area for improvement in BigQuery is its UI because it's not working very well. Pricing for the solution is also very high."
"There is a good amount of documentation out there, but they're consistently making changes to the platform, and, like, their literature hasn't been updated on some plans."
"I noticed recently it's more expensive now."
"Some of the queries are complex and difficult to understand."
"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."
"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."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
 

Pricing and Cost Advice

"We are above the free threshold, so we are paying around 40 euros per month for BigQuery."
"The tool has competitive pricing."
"Its cost structure operates on a pay-as-you-go model."
"1 TB is free of cost monthly. If you use more than 1 TB a month, then you need to pay 5 dollars extra for each TB."
"The platform is inexpensive."
"The price could be better. Usually, you need to buy the license for a year. Whenever you want more, you can subscribe to it, and you can use it. Otherwise, you can terminate the license. You can use it daily or monthly, and we use it based on a project's requirements."
"BigQuery pricing can increase quickly. It's a high-priced solution."
"The pricing appears to be competitive for the intended usage scenarios we have in mind."
"If your going to go with warehouse DB/dashDB, use the cloud or Sailfish version."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
869,566 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
11%
Retailer
7%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise9
Large Enterprise20
By reviewers
Company SizeCount
Small Business4
Large Enterprise3
 

Questions from the Community

What do you like most about BigQuery?
The initial setup process is easy.
What is your experience regarding pricing and costs for BigQuery?
I believe the cost of BigQuery is competitive versus the alternatives in the market, but it can become expensive if the tool is not used properly. It is on a per-consumption basis, the billing, so ...
What needs improvement with BigQuery?
I have not used BigQuery for AI and machine learning projects myself. I know how to use it, and I can see where it would be useful, but so far, in my projects, I have not included a BigQuery compon...
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.
 

Also Known As

No data available
IBM dashDB
 

Overview

 

Sample Customers

Information Not Available
Copenhagen Business School, BPM Northwest, GameStop
Find out what your peers are saying about BigQuery vs. IBM Db2 Warehouse on Cloud and other solutions. Updated: September 2025.
869,566 professionals have used our research since 2012.