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."
"The performance is okay as long as the volume of queries is not too high."
"It will be MPP, so performance should improve."
"The initial setup is very simple."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"It is very fast and the performance is great."
"It helped us to build MVP (minimum viable product) for our idea of building a data warehouse model for small businesses."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"The Time Travel feature is helpful for accessing historical data and the ability to clone external tables is useful."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications."
"Ultimately, the product itself has challenges and we are not currently satisfied with the support, either."
"Containers get corrupted very easily. Restoring them using GPFS can result in a lot of issues."
"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."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"I would like to see more transparency in data processing, ATLs, and compute areas - which should give more comfort to the end users."
"We are yet to figure out how to integrate tools, such as Liquibase, to release changes to our data warehouse model."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"Their strategy is just to leverage what you've got and put Snowflake in the middle. It does work well with other tools. You have to buy a separate reporting tool and a separate data loading tool, whereas, in some platforms, these tools are baked in. In the long-term, they'll need to add more direct partnerships to the ecosystem so that it's not like adding on tools around Snowflake to make it work. They can also consider including Snowflake native reporting tools versus partnering with other reporting tools. It would kind of change where they sit in the market."
"There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL Server, but it is not there in Snowflake. So, you have to write complex code for it."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"More data governance and access control features would be a welcome addition."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
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 Netezza Performance Server, IBM Db2 Warehouse 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.