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."Provides good security and reliability."
"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."
"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 solution is stable."
"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."
"Data Science capabilities are the most valuable feature."
"A user-friendly and reliable solution."
"The product's most important feature is unloading data to S3."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"Snowflake is scalable both in terms of the amount of data that you can run through it and the number of users that engage with it."
"The feature that is really striking is the ability to translate the SQL workloads into the NoSQL version that can be used by Snowflake."
"The way it is built and designed is valuable. The way the shared model is built and the way it exploits the power of the cloud is very good. Certain features related to administration and management, akin to Oracle Flashback and all that, are very important for modern-day administration and management. It is also good in terms of managing and improving performance, indexing, and partitioning. It is sort of completely automated. Everything is essentially under the hood, and the engine takes care of it all. As a data warehouse on the cloud, Snowflake stands strong on its ground even though each of the cloud providers has its own data warehouse, such as Redshift for AWS or Synapse for Azure."
"Working with Parquet files is support out of the box and it makes large dataset processing much easier."
"There were some initial challenges with IBM Db2 Warehouse about eight months ago when I worked in this environment. When I coordinated with IBM support, they mentioned that the memory was insufficient for our needs. Our business environment required significantly more memory than the previous cluster could provide. Consequently, we have worked closely with on-site IBM technical personnel to address this issue."
"The areas of the solution that is needing the most improvement are separating compute from storage, elasticity, which means scaling up and then retracting."
"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."
"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."
"In terms of improvement, IBM Db2 Warehouse should be more scalable."
"Lacks sufficient documentation and particularly in Spanish."
"The cost is a bit high."
"The UI could improve because sometimes in the security query the UI freezes. We then have to close the window and restart."
"Currently, Snowflake doesn't support unstructured data."
"Snowflake can improve its machine learning and AI capabilities."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
"Their UiPath, the workspace area, needs some work."
"The cost of the solution could be reduced."
IBM Db2 Warehouse is ranked 12th in Data Warehouse with 9 reviews while Snowflake is ranked 1st in Data Warehouse with 95 reviews. IBM Db2 Warehouse is rated 7.8, 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, IBM Db2 Warehouse on Cloud, Apache Hadoop and Teradata, 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.