"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"We find the data sharing and data marketplace aspects of Snowflake absolutely amazing."
"The solution is very easy to use."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"It was relatively easy to use, and it was easy for people to convert to it."
"The speed of data loading and being able to quickly create the environment are most valuable."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"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."
"The data sharing capabilities across business units within the organization should be better."
"There could be better ELT tools that are appropriate for Snowflake. We decided on Matillion and it seemed to be the only one. There need to be better choices, it would be great if Snowflake provided an ELT solution that people could use. Additionally, if there was a pure cloud-based ELT tool it would be useful."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"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."
"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."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
IBM Netezza Performance Server is ranked 8th in Data Warehouse with 2 reviews while Snowflake is ranked 1st in Data Warehouse with 47 reviews. IBM Netezza Performance Server is rated 8.6, while Snowflake is rated 8.4. The top reviewer of IBM Netezza Performance Server writes "We are now able to analyze products, stores, suppliers and sales as quickly as we need". 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, SQL Server, Microsoft Azure Synapse Analytics, IBM Db2 Database and Teradata, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Vertica and Teradata.
See our list of best 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.