Microsoft Parallel Data Warehouse vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
564 views|446 comparisons
84% willing to recommend
Snowflake Computing Logo
493 views|330 comparisons
100% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Microsoft Parallel Data Warehouse and Snowflake Analytics 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.
To learn more, read our detailed Microsoft Parallel Data Warehouse vs. Snowflake Analytics Report (Updated: March 2024).
769,599 professionals have used our research since 2012.
Featured Review
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 feature is the business intelligence (BI) part of it.""One of the most important features is the ease of using MS SQL.""It is a stable solution...It is a scalable solution.""The most valuable feature of this solution is performance.""I am very satisfied with the customer service/technical support.""The solution has been reliable.""Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.""It performs very well overall."

More Microsoft Parallel Data Warehouse Pros →

"Snowflake Analytics is pretty easy to use with the connectors for integration with the tools and systems in my company.""One of the valuable features is the solution’s time travel capability. The solution is highly stable. The solution is highly scalable. The initial setup is straightforward, and the deployment process is quick and efficient. I recommend the solution. Overall, I rate it a perfect ten.""Deployment is straightforward as it's a SaaS product. No maintenance required.""It is an all-in-one platform that provides the capabilities needed for various analytics tasks, including data warehousing for machine learning.""What we found most valuable in Snowflake Analytics are its attributes that are very convenient for business use such as data sharing, cloning, time travel, and fail-safe. It's a good product all in all.""It ensures the optimization of the application development while maintaining the user-friendly nature of its UI.""One of the key advancements in Snowflake Analytics is data sharing.""The solution auto-scales and it provides concurrency."

More Snowflake Analytics Pros →

Cons
"The only issue with the product is that the process is very slow when we have a huge amount of data.""They need to incorporate a machine learning engine.""It could be made more user-friendly for business users which would increase the user base.""The query is slow if we don't optimize it.""The reporting for certain types of data needs to be improved.""The product does not have all of the features that the native products have.""Some compatibility issues occur during deployment, so we need to build the product from scratch for some features.""The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."

More Microsoft Parallel Data Warehouse Cons →

"If you have a lot of computations, it becomes very costly.""Snowflake could improve in the areas of advanced machine learning AML and generative AI.""Snowflake's Snowpark is an area of concern where improvements are required.""Snowflake Analytics can improve the integration with machine learning tools and AI and it will make the solution more usable.""The solution needs to consider including some updates in the future.""The solution’s interface is good but it could be improved.""One area that could benefit from enhancement is the user interface for more visual ESM features.""The solution's high price can be an area of concern that needs improvement."

More Snowflake Analytics Cons →

Pricing and Cost Advice
  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse Pricing and Cost Advice →

  • "Snowflake Analytics is a little more costly than Azure."
  • "When using Snowflake, you pay based on your usage. They calculate how much CPU has been used. If you use excess warehouse storage, you are charged one credit per hour. If you are in Asia, you are charged $3 per credit. If you have 10 users running parallel with the same excess, you will be charged $30."
  • "The cost of Snowflake Analytics is low, any small organization can use it."
  • "The solution's price is high and I would rate it an eight out of ten."
  • "On a scale of one to ten, where one is a low price, and ten is a high price, I rate the pricing a seven. The solution's pricing is high."
  • "It is an expensive solution, but the kind of usability and flexibility it proactively provides for the organizations justify the price."
  • "The tool is quite expensive."
  • "Snowflake Analytics is not an expensive solution, and its pricing is average."
  • More Snowflake Analytics Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    769,599 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    Top Answer:The Snowflake features I find most beneficial for data analysis are primarily related to analytics, particularly their features like materialized views and queues, which are especially useful for… more »
    Top Answer:The pricing is on the higher side. I would rate it seven out of ten.
    Top Answer:The scheduling of jobs requires improvement, particularly in terms of the user interface which currently lacks certain features found in comparable platforms.
    Ranking
    8th
    out of 35 in Data Warehouse
    Views
    564
    Comparisons
    446
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    6th
    Views
    493
    Comparisons
    330
    Reviews
    30
    Average Words per Review
    486
    Rating
    8.4
    Comparisons
    Also Known As
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    Conventional data platforms and big data solutions struggle to deliver on their fundamental purpose: to enable any user to work with any data, without limits on scale, performance or flexibility. Whether you’re a data analyst, data scientist, data engineer, or any other business or technology professional, you’ll get more from your data with Snowflake.

    To achieve this, we built a new data platform from the ground up for the cloud. It’s designed with a patented new architecture to be the centerpiece for data pipelines, data warehousing, data lakes, data application development, and for building data exchanges to easily and securely share governed data. The result, A platform delivered as a service that’s powerful but simple to use.

    Snowflake’s cloud data platform supports a multi-cloud strategy, including a cross-cloud approach to mix and match clouds as you see fit. Snowflake delivers advantages such as global data replication, which means you can move your data to any cloud in any region, without having to re-code your applications or learn new skills.

    Sample Customers
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
    Top Industries
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company19%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    REVIEWERS
    Computer Software Company31%
    Financial Services Firm31%
    Outsourcing Company15%
    Retailer8%
    VISITORS READING REVIEWS
    Computer Software Company17%
    Manufacturing Company9%
    Financial Services Firm8%
    Retailer8%
    Company Size
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise18%
    Large Enterprise65%
    REVIEWERS
    Small Business22%
    Midsize Enterprise25%
    Large Enterprise53%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise18%
    Large Enterprise63%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. Snowflake Analytics
    March 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Snowflake Analytics and other solutions. Updated: March 2024.
    769,599 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Snowflake Analytics is ranked 6th in Cloud Data Warehouse with 30 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Snowflake Analytics is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of Snowflake Analytics writes "A scalable tool useful for data lake and data mining processes". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Greenplum, whereas Snowflake Analytics is most compared with Azure Data Factory, Adobe Analytics, Mixpanel, Amplitude and Glassbox. See our Microsoft Parallel Data Warehouse vs. Snowflake Analytics report.

    See our list of best Cloud 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.