IT Central Station is now PeerSpot: Here's why

IBM Netezza Performance Server vs Snowflake comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
Data Warehouse
July 2022
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: July 2022.
620,319 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."

More IBM Netezza Performance Server Pros →

"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."

More Snowflake Pros →

Cons
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."

More IBM Netezza Performance Server Cons →

"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."

More Snowflake Cons →

Pricing and Cost Advice
Information Not Available
  • "On average, with the number of queries that we run, we pay approximately $200 USD per month."
  • "Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
  • "The price of Snowflake is very reasonable."
  • "The price of Snowflake is quite reasonable."
  • "Its price should be improved. It should be cheaper than Microsoft."
  • "It is per credit. It has a use-it-as-you-go model. We bought a chunk of 20,000 credits, and they were lasting us for at least a year. We didn't have the scale of data like a much larger company to consume more credits. For us, it was very inexpensive. Their strategy is just to leverage what you've got and put Snowflake in the middle. It doesn't make it expensive because most of the organizations already have reporting tools. Now, if you were starting from scratch, it might be cheaper to go a different way."
  • "We used Snowflake to see if it is cheaper than using BigQuery. It was just to maintain the cost or the KPI regarding the cost of connectivity by users. Snowflake wasn't cheaper than BigQuery, and its affordability was the main issue."
  • "Currently, we have a trial account, so we don't need a license. After our project starts, we would need a permanent license."
  • More Snowflake Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    620,319 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:We looked at performance server to replace our MAKO Appliances  IPS is really NPS 7.2.  Concurrency was still set at 48.  Performance server didn't make it to our POC. Take a look at Snowflake… more »
    Top Answer:If you're still looking, we might be able to help. Take a look at https://smart-associates.biz/s...
    Top Answer:This is the advanced version of the cloud version, so it's really a flexible tool. If you have it implemented at home, you can access it from anywhere.
    Top Answer:They have different pricing structures based on data usage. I think they have three or four tiers you can scale through. Most of the clients see an advantage from this type of licensing. That's the… more »
    Top Answer:Sometimes when I'm trying to refresh the data, my different application or tool has to connect to its backend database through the connection I create. Sometimes, I face some issues like not having… more »
    Ranking
    8th
    out of 30 in Data Warehouse
    Views
    5,626
    Comparisons
    4,159
    Reviews
    2
    Average Words per Review
    505
    Rating
    8.5
    1st
    out of 30 in Data Warehouse
    Views
    39,423
    Comparisons
    29,410
    Reviews
    48
    Average Words per Review
    559
    Rating
    8.4
    Comparisons
    Also Known As
    Netezza Performance Server, Netezza
    Snowflake Computing
    Learn More
    Overview
    IBM Netezza appliances are now part of IBM PureSystems - expert integrated systems with built in expertise, integration by design and a simplified user experience. Part of the PureData family, the Netezza appliance is now known as the PureData System for Analytics. It has the same key design tenets of simplicity, speed, scalability and analytics power that was fundamental to Netezza appliances.

    Snowflake is a fully managed SaaS (software as a service) that provides a single platform for data warehousing, data lakes, data engineering, data science, data application development, and secure sharing and consumption of real-time / shared data.

    Its platform is made up of three components:

    1. Cloud services: As part of its cloud services, Snowflake uses ANSI SQL, which empowers users to optimize their data and manage their infrastructure, while Snowflake handles the security and encryption of stored data.
    1. Query processing: With Snowflake, workload concurrency is never a problem because its compute layer is made up of virtual cloud data warehouses that let you analyze data through requests. Each of the warehouses do not compete for computing resources nor do they affect the performance of each other.
    1. Database storage: Snowflake manages all parts of the data storage process automatically, including file size, compression, organization, structure, and metadata, as well as statistics.

    Snowflake Features

    Snowflake has many valuable key features. Some of the most useful ones include:

    • Scalability: Snowflake architecture provides nearly unlimited scalability and high speed because it uses a single elastic performance engine. The solution also supports an unlimited amount of concurrent users and workloads, from interactive to batch.
    • Automation: Snowflake makes automation easy and enables enterprises to automate data management, security, governance, availability, and data resiliency.
    • Seamless cross-cloud and cross-region connections: With seamless cross-cloud and cross-region connections, Snowflake eliminates ETL and data silos. Anyone who needs access to shared secure data can get a single copy via the data cloud. In addition, Snowflake makes remote collaboration and decision-making fast and easy via a single shared data source.
    • Third-party data integrations: Snowflake’s Data Marketplace offers third-party data which allows you to connect with Snowflake customers to extend workflows with data services and third-party applications.

    Snowflake Benefits

    There are many benefits to implementing Snowflake. Some of the biggest advantages the solution offers include:

    • Helps optimize costs
    • Reduces downtime
    • Improves operational efficiency
    • Built for high reliability and availability
    • Automates data replication for fast recovery

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the Snowflake solution.

    Sreenivasan R., Director of Data Architecture and Engineering at Decision Minds, says, "Data sharing is a good feature. It is a majorly used feature. The elastic compute is another big feature. Separating compute and storage gives you flexibility. It doesn't require much DBA involvement because it doesn't need any performance tuning. We are not really doing any performance tuning, and the entire burden of performance tuning and SQL tuning is on Snowflake. Its usability is very good. I don't need to ramp up any user, and its onboarding is easier. You just onboard the user, and you are done with it. There are simple SQL and UI, and people are able to use this solution easily. Ease of use is a big thing in Snowflake."

    A director of business operations at a logistics company mentions, "It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."

    A Solution Architect at a wholesaler/distributor comments, "The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."

    Offer
    Learn more about IBM Netezza Performance Server
    Learn more about Snowflake
    Sample Customers
    Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods
    Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
    Top Industries
    REVIEWERS
    Financial Services Firm35%
    Retailer18%
    Comms Service Provider12%
    Insurance Company12%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Financial Services Firm16%
    Comms Service Provider12%
    Insurance Company10%
    REVIEWERS
    Computer Software Company39%
    Financial Services Firm12%
    Manufacturing Company9%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider13%
    Financial Services Firm10%
    Insurance Company6%
    Company Size
    REVIEWERS
    Small Business15%
    Midsize Enterprise9%
    Large Enterprise76%
    VISITORS READING REVIEWS
    Small Business12%
    Midsize Enterprise10%
    Large Enterprise77%
    REVIEWERS
    Small Business24%
    Midsize Enterprise23%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    Buyer's Guide
    Data Warehouse
    July 2022
    Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: July 2022.
    620,319 professionals have used our research since 2012.

    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.