We performed a comparison between IBM Db2 Warehouse on Cloud and Snowflake based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."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."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"The technical support on offer is excellent."
"All the people who are working with Snowflake are extremely happy with it because it is designed from a data-warehousing point of view, not the other way around. You have a database and then you tweak it and then it becomes a data warehouse."
"Scaling is a big plus point of Snowflake."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"This solution has helped our organization by being easy to maintain and having good technical support."
"The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs."
"The solution speeds up the process of onboarding."
"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."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"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."
"There are some stored procedures that we've had trouble with. The solution also needs to fine-tune the connectors to be able to connect into the system source."
"They don't have any SLAs in place. It would be better if they did."
"The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"Getting data out of the tool to third-party applications is difficult."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
IBM Db2 Warehouse on Cloud is ranked 15th in Cloud Data Warehouse while Snowflake is ranked 1st in Cloud Data Warehouse with 92 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 Amazon Redshift, IBM Db2 Warehouse, 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 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.