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."Some of the best features are stored procedures, parallelism, and different indexing strategies."
"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."
"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."
"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 product is quite fast."
"It is a highly scalable solution. There is no limit on storage or computing."
"Great scalability and near zero maintenance."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere."
"Data Science capabilities are the most valuable feature."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"IBM Db2 Warehouse needs to improve its interface."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"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."
"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."
"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."
"There should be more material available for training and training should be free."
"Its stability could be better."
"I have heard people having difficulty with the machine learning model, so there may be room for improvement."
"This solution could be improved by offering machine learning apps."
"They should improve the reporting tools."
"The design of the product is easily misunderstood."
"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 data science functionality could be improved in terms of the machine learning process."
"In future releases, it can also support full unstructured data."
IBM Db2 Warehouse is ranked 14th 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, IBM Db2 Warehouse on Cloud and BigQuery, 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.