We performed a comparison between IBM Netezza Performance Server 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."IBM Netezza Performance Server is a cost-effective solution."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"Distribution concurrency control."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"Snowflake's most valuable features are data enrichment and flattening."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"Time travel is one feature that really helps us out."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured data."
"Snowflake is a database, and it is very good and useful. The most interesting part is that memory management is very good in Snowflake. For a business intelligence project, SQL Server is taking a lot of time for reporting services. There are a lot of calculations, and the reporting time is shown as two minutes, whereas Snowflake is taking just two seconds for the same reporting services."
"The solution's customer service is good."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"The scalability is not as expected. The capacity in the black box is not enough."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"Concurrency limit needs to be increased somewhat."
"There is a need for improvements in the documentation, this would allow more people to switch over to this solution."
"This solution could be improved by offering machine learning apps."
"The price could be improved."
"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."
"They do have a native connector to connect with integration tools for loading data, but it would be much better to have the functionality built-in."
"The product's performance could be improved."
"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."
"If we can have a feature where the results can be moved to different tabs, so that I can compare the results with earlier queries before applying the changes, it would be great."
More IBM Netezza Performance Server Pricing and Cost Advice →
IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. IBM Netezza Performance Server is rated 8.0, while Snowflake is rated 8.4. The top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". 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 Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Teradata, SQL Server and IBM Db2 Database, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our IBM Netezza Performance Server 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.