Compare Microsoft Parallel Data Warehouse vs. Snowflake

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Snowflake and other solutions. Updated: September 2020.
437,323 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
Tools like the BI and SAS are excellent.It is not a pricey product compared to other data warehouse solutions.Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it.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 feature is the business intelligence (BI) part of it.The data transmissions between the data models is the most valuable feature.The most valuable feature of this solution is performance.One of the most important features is the ease of using MS SQL.

More Microsoft Parallel Data Warehouse Pros »

The querying speed is fast.The solution is very stable.From a data warehouse perspective, it's an excellent all-round solution. It's very complete.The snapshot feature is good, the rollback feature is good and the interface is user-friendly.The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.I like the idea that you can assign roles and responsibilities, limiting access to data.It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.The thing I find most valuable is that scalability, space storage, and computing power is separate. When you scale up, it is live from one second to the next — constantly available as you scale — so there is no downtime or interruption of services.

More Snowflake Pros »

Cons
We find the cost of the solution to be a little high.It could be made more user-friendly for business users which would increase the user base.They need to incorporate a machine learning engine.I would like the tool to support different operating systems.If the database is large with a lot of columns then it is difficult to clean the data.This solution would be improved with an option for in-memory data analysis.The reporting for certain types of data needs to be improved.I think that the error messages need to be made more specific.

More Microsoft Parallel Data Warehouse Cons »

We would like to have an on-premises deployment option that has the same features, including scalability.They don't have any SLAs in place. It would be better if they did.The user interface continues to be an issue, especially when we need to get data out of Snowflake. It's very easy to get data in, but it's not too easy to get it out or extract it.Availability is a problem.If you go with one cloud provider, you can't switch.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.Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.The solution could improve the user interface and add functionality to the system.

More Snowflake Cons »

Pricing and Cost Advice
All the features that we use do not require any additional subscription or yearly fees.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.I think the program is well-priced compared to the other offerings that are out in the market.

More Microsoft Parallel Data Warehouse Pricing and Cost Advice »

The pricing for Snowflake is competitive.It is not cheap.You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.The whole licensing system is based on credit points. You can also make a license agreement with the company so that you buy credit points and then you use them. What you do not use in one year can be carried over to the next year.Pricing can be confusing for customers.

More Snowflake Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
437,323 professionals have used our research since 2012.
Questions from the Community
Top Answer: Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity… more »
Top Answer: 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… more »
Top Answer: The setup has room for improvement. Some customers want to go to non-Windows Servers. Have the entire SQL Server done there though is an obstacle for us, as the configuration of Microsoft BI with… more »
Top Answer: Interactive querying as a consumption pattern is something Snowflake handles much better than Hadoop and related query engine options - Impala, Presto, Drill etc. Heavy data scientists query workload… more »
Top Answer: The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.
Ranking
6th
out of 32 in Data Warehouse
Views
2,637
Comparisons
1,942
Reviews
11
Average Words per Review
486
Avg. Rating
7.6
1st
out of 32 in Data Warehouse
Views
25,092
Comparisons
16,849
Reviews
13
Average Words per Review
570
Avg. Rating
8.4
Popular Comparisons
Compared 9% of the time.
Compared 9% of the time.
Compared 8% of the time.
Also Known As
Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data WarehouseSnowflake Computing
Learn
Microsoft
Snowflake Computing
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.

Snowflake provides a data warehouse built for the cloud, delivering a solution capable of solving problems for which legacy, on-premises and cloud data platforms were not designed.

Offer
Learn more about Microsoft Parallel Data Warehouse
Learn more about Snowflake
Sample Customers
Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel EuropeAccordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
REVIEWERS
Computer Software Company27%
Comms Service Provider9%
Healthcare Company9%
Hospitality Company9%
VISITORS READING REVIEWS
Computer Software Company36%
Media Company9%
Wholesaler/Distributor7%
Financial Services Firm7%
VISITORS READING REVIEWS
Computer Software Company41%
Comms Service Provider10%
Media Company7%
Financial Services Firm6%
Company Size
REVIEWERS
Small Business38%
Midsize Enterprise14%
Large Enterprise48%
REVIEWERS
Small Business19%
Midsize Enterprise13%
Large Enterprise69%
VISITORS READING REVIEWS
Small Business3%
Midsize Enterprise16%
Large Enterprise81%
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. Snowflake and other solutions. Updated: September 2020.
437,323 professionals have used our research since 2012.
Microsoft Parallel Data Warehouse is ranked 6th in Data Warehouse with 11 reviews while Snowflake is ranked 1st in Data Warehouse with 13 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Snowflake is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "Collects data through SSIS packages from different sources and puts them all in one data repository". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure SQL Data Warehouse, Oracle Exadata, VMware Tanzu Greenplum, Teradata and IBM Netezza Performance Server, whereas Snowflake is most compared with Microsoft Azure SQL Data Warehouse, Apache Hadoop, Vertica, Amazon Redshift and IBM Db2 Warehouse on Cloud. See our Microsoft Parallel Data Warehouse 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.