IBM Db2 Warehouse vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
IBM Logo
962 views|511 comparisons
71% willing to recommend
Snowflake Computing Logo
493 views|330 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

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

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed IBM Db2 Warehouse vs. Snowflake Analytics Report (Updated: March 2024).
770,765 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"I think it scales really well and as long as you take enough time to learn a little bit about it, it works really well.""Some of the best features are stored procedures, parallelism, and different indexing strategies.""The analytics engine is not bad at forecasting predictions.""The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.""Provides good security and reliability.""It can be mounted on the cloud, which is a huge plus. If the client, for example, starts small with on-premise deployment and then it rapidly needs to grow, we can transfer this to the cloud easily."

More IBM Db2 Warehouse Pros →

"It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning.""Deployment is straightforward as it's a SaaS product. No maintenance required.""The most valuable feature of Snowflake Analytics is its performance.""The most valuable feature of Snowflake Analytics is the ability to control and manage the cost.""I am impressed with the product's data-sharing feature.""The solution auto-scales and it provides concurrency.""The performance has been good.""It is quite a convenient tool."

More Snowflake Analytics Pros →

Cons
"There should be more material available for training and training should be free.""In terms of improvement, IBM Db2 Warehouse should be more scalable.""The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting.""The biggest problems we have is when the backup solution is failing or slow and we run out of log space, which has happened probably a couple of times in the last four years.""Lacks sufficient documentation and particularly in Spanish.""IBM Db2 Warehouse needs to improve its interface.""The biggest challenge anyone could have with Db2 Warehouse is their references or online resources and documentation. They are very, very, very limited on the web."

More IBM Db2 Warehouse Cons →

"Integration into different Python and Jupyter notebooks needs to be improved.""Moving data from legacy systems to Snowflake is not that easy. There are some cases where processors are not actually compatible with Snowflake.""Snowflake should include a WHERE clause for building data pipelines.""A room for improvement in Snowflake Analytics is Spark, particularly its connector for Spark. An additional feature I'd like to see in the next release of the solution is built-in analytics.""The platform's data governance space needs more capability.""The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms.""Snowflake's Snowpark is an area of concern where improvements are required.""Snowflake could improve in the areas of advanced machine learning AML and generative AI."

More Snowflake Analytics Cons →

Pricing and Cost Advice
  • "In a traditional on-prem database, in a data warehouse, the solution is probably on the expensive side."
  • More IBM Db2 Warehouse Pricing and Cost Advice →

  • "Snowflake Analytics is a little more costly than Azure."
  • "When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30."
  • "The cost of Snowflake Analytics is low, any small organization can use it."
  • "The solution's price is high and I would rate it an eight out of ten."
  • "On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high."
  • "It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
  • "The tool is quite expensive."
  • "Snowflake Analytics is not an expensive solution, and its pricing is average."
  • More Snowflake Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    770,765 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The standout feature of IBM Db2 Warehouse, which is particularly valuable for large enterprises, is its ability to handle big data.
    Top Answer:Db2 is a very expensive database. In comparison to Oracle, for example, where the cost depends on the size of the implementation. For an enterprise database, the cost is mid-range.
    Top Answer:IBM Db2 Warehouse needs to improve its interface.
    Top Answer:The pricing is on the higher side. I would rate it seven out of ten.
    Top Answer:I haven't noticed any limitations with the solution. There could be more analytics. We find that IBM has a lot of pro data analytics that we use. The distribution methodology isn't as strong as… more »
    Ranking
    13th
    out of 35 in Data Warehouse
    Views
    962
    Comparisons
    511
    Reviews
    3
    Average Words per Review
    363
    Rating
    7.3
    6th
    Views
    493
    Comparisons
    330
    Reviews
    30
    Average Words per Review
    486
    Rating
    8.4
    Comparisons
    Also Known As
    InfoSphere Warehouse, IBM InfoSphere Warehouse
    Learn More
    IBM
    Video Not Available
    Overview
    InfoSphere Warehouse is a suite of products that combines the strength of DB2 with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools.

    Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.

    To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.

    Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.

    Sample Customers
    Alameda County Social Services Agency, Sui Southern Gas Company Limited
    Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
    Top Industries
    VISITORS READING REVIEWS
    Educational Organization52%
    Financial Services Firm9%
    Computer Software Company7%
    Insurance Company5%
    REVIEWERS
    Computer Software Company31%
    Financial Services Firm31%
    Outsourcing Company15%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Financial Services Firm9%
    Manufacturing Company9%
    Retailer8%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise20%
    Large Enterprise40%
    VISITORS READING REVIEWS
    Small Business9%
    Midsize Enterprise55%
    Large Enterprise36%
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise18%
    Large Enterprise63%
    Buyer's Guide
    IBM Db2 Warehouse vs. Snowflake Analytics
    March 2024
    Find out what your peers are saying about IBM Db2 Warehouse vs. Snowflake Analytics and other solutions. Updated: March 2024.
    770,765 professionals have used our research since 2012.

    IBM Db2 Warehouse is ranked 13th in Data Warehouse with 8 reviews while Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews. IBM Db2 Warehouse is rated 7.6, while Snowflake Analytics is rated 8.4. The top reviewer of IBM Db2 Warehouse writes "Useful for ETL process and has good documentation ". On the other hand, the top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". IBM Db2 Warehouse is most compared with Oracle Exadata, Snowflake, Amazon Redshift, Apache Hadoop and Teradata, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our IBM Db2 Warehouse vs. Snowflake Analytics report.

    See our list of best Cloud Data Warehouse vendors.

    We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.