We performed a comparison between IBM Db2 Warehouse and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"Provides good security and reliability."
"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."
"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."
"Some of the best features are stored procedures, parallelism, and different indexing strategies."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"The solution speeds up the process of onboarding."
"For us, the virtual warehousing is likely the most valuable aspect."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"It is a highly scalable solution. There is no limit on storage or computing."
"Snowflake's most valuable features are data enrichment and flattening."
"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."
"Lacks sufficient documentation and particularly in Spanish."
"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."
"There should be more material available for training and training should be free."
"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."
"IBM Db2 Warehouse needs to improve its interface."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"The data science functionality could be improved in terms of the machine learning process."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
"The solution could use a little bit more UI."
"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."
"In a future release we would like to have a link which would allow us to connect to an external database and create certain views in your own database. This is because it is becoming hard for us to compare the data between multiple sources."
"Some SQL language functions could be included."
IBM Db2 Warehouse is ranked 13th in Data Warehouse with 8 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. IBM Db2 Warehouse is rated 7.6, while Snowflake 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 writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". IBM Db2 Warehouse is most compared with Oracle Exadata, Amazon Redshift, Apache Hadoop, Teradata and IBM Db2 Warehouse on Cloud, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our IBM Db2 Warehouse vs. Snowflake report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.