We performed a comparison between Microsoft Parallel Data Warehouse and Snowflake based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"I am very satisfied with the customer service/technical support."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The most valuable feature for me is querying."
"It performs very well overall."
"The data transmissions between the data models is the most valuable feature."
"It is a very stable database."
"It is a stable solution...It is a scalable solution."
"The ETL and data ingestion capabilities are better in this solution as compared to SQL Server. SQL Server doesn't do much data ingestion, but Snowflake can do it quite conveniently."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The product's most important feature is unloading data to S3."
"It is a cloud solution with many useful features. It has the data science capability. It can transform data and prepare data for a data science project with scalability."
"From a data warehouse perspective, it's an excellent all-round solution. It's very complete."
"Can be leveraged with respect to better performance, auto tuning and competition."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"The most valuable feature of Snowflake is its performance. We can access the data quickly. Additionally, it handles structured and non-structured 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."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"The product does not have all of the features that the native products have."
"The query is slow if we don't optimize it."
"They need to incorporate a machine learning engine."
"I think that the error messages need to be made more specific."
"It needs more compatibility with common BI tools."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"Its stability could be better."
"Room for improvement would be writebacks. It doesn't support extensively writing back to the database, and it doesn't support web applications effectively. Ultimately, it's a database call, so if we are building web applications using Snowflake, it isn't that effective because there is some turnaround time from the database."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"The cost is a bit high."
"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."
"The product's performance could be improved."
"Product activation queries can't be changed while executing."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 12 reviews while Snowflake is ranked 1st in Data Warehouse with 39 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Snowflake is rated 8.4. The top reviewer of Microsoft Parallel Data Warehouse writes "User-friendly UI and good support". On the other hand, the top reviewer of Snowflake writes "Easy to set up with great cloning and time travel". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA and VMware Tanzu Greenplum, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. 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.