We performed a comparison between IBM Db2 Warehouse on Cloud and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The performance is okay as long as the volume of queries is not too high."
"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."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"The product's most important feature is unloading data to S3."
"It is quite easy to manage."
"The snapshot feature is good, the rollback feature is good and the interface is user-friendly."
"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."
"The pricing is reasonable and matches the rest of the market."
"As long as you don't need to worry about the storage or cost, this solution would be one of the best ones on the market for scalability purposes."
"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."
"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."
"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."
"Tech support for dashDB is awful. We usually have tickets open for three to four weeks."
"The solution could improve by allowing non-structured data, such as PDFs, images, or videos. We cannot see the data."
"Snowflake could improve if they had an Operational Data Store(ODS) space."
"For the Snowflake database, there should be some third-party features for the ETL. It would also be good to be able to use some kind of controls to get the data either from another database or a flat file. Its price should be improved. It should be cheaper than Microsoft."
"If they could bring in some tools for data integration, it would be really great."
"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."
"It's not that flexible when compared to Oracle."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Currently, Snowflake doesn't support unstructured data."
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 IBM Db2 Warehouse on Cloud vs. Snowflake report.
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.