Microsoft Parallel Data Warehouse vs Snowflake Analytics comparison

Cancel
You must select at least 2 products to compare!
Microsoft Logo
598 views|475 comparisons
84% willing to recommend
Snowflake Computing Logo
493 views|334 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).
768,578 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 of this solution is performance.""Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products.""It is a stable solution...It is a scalable solution.""The solution has been reliable.""I am very satisfied with the customer service/technical support.""It performs very well overall.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.""The most valuable features are the performance and usability."

More Microsoft Parallel Data Warehouse Pros →

"Time Travel and Snowpipe are good features.""Its performance speed is very good.""Scaling is very high – there's no problem for scaling purposes. The learning curve is very small. And there are a lot of advanced features like handling duplicates, security, data governance, data sharing, and data cloning.""Very good flexibility and it offers computation completely decoupled from the storage.""I am impressed with the product's data-sharing feature.""Considering everything I have accessed, the product's dashboard is good since it provides multiple good options, including customization options.""Snowflake Analytics' most valuable feature is its inbuilt infrastructure for executing queries, which I don't have to manage based on my data volume as it's taken care of by Snowflake.""Scalability-wise, I rate the solution a ten out of ten."

More Snowflake Analytics Pros →

Cons
"The product does not have all of the features that the native products have.""​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""It could offer more development across the solution.""The product must provide more frequent updates.""The only issue with the product is that the process is very slow when we have a huge amount of data.""Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.""If the database is large with a lot of columns then it is difficult to clean the data.""In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating."

More Microsoft Parallel Data Warehouse Cons →

"I cannot comment on the product's stability because we are still struggling with its performance.""Snowflake's Snowpark is an area of concern where improvements are required.""The product's cost is an area of concern where improvements are required.""Integration into different Python and Jupyter notebooks needs to be improved.""End-to-end execution of jobs isn't possible with Snowflake, which means we have to do some customization.""The solution’s interface is good but it could be improved.""The technical support is not very good.""Snowflake should include a WHERE clause for building data pipelines."

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.
    768,578 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 34 in Data Warehouse
    Views
    598
    Comparisons
    475
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    7th
    Views
    493
    Comparisons
    334
    Reviews
    27
    Average Words per Review
    455
    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 Company20%
    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 Enterprise62%
    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.
    768,578 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 7th in Cloud Data Warehouse with 29 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, VMware Tanzu Greenplum and Snowflake, 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.