We performed a comparison between IBM Db2 Warehouse on Cloud and Snowflake 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."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 performance is okay as long as the volume of queries is not too high."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The product is quite fast."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"It was relatively easy to use, and it was easy for people to convert to it."
"The solution is very stable."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"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."
"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."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"If you go with one cloud provider, you can't switch."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"They should improve the reporting tools."
"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."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"They don't have any SLAs in place. It would be better if they did."
"It doesn't enforce typical relational database constraints. Quite expensive."
"Snowflake needs to improve its programming part. Though the tool has Snowpath, it doesn’t support all features like its competitor, Databricks. Snowflake doesn’t support external data ingestion capabilities. You need to have third-party tools for that. Also, the tool needs to incorporate data integration features in its future releases."
IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Snowflake is ranked 1st in Cloud Data Warehouse with 94 reviews. IBM Db2 Warehouse on Cloud is rated 7.6, while Snowflake is rated 8.4. The top reviewer of IBM Db2 Warehouse on Cloud writes "The "prefetch" feature anticipates needed data and keeps it available. BLU acceleration determines what data is unqualified for analysis and skips it". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". IBM Db2 Warehouse on Cloud is most compared with IBM Db2 Warehouse, Amazon Redshift, IBM Netezza Performance Server and Microsoft Azure Synapse Analytics, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our IBM Db2 Warehouse on Cloud vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors and best 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.