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."We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"It is a very stable database."
"The most valuable feature of this solution is performance."
"It is not a pricey product compared to other data warehouse solutions."
"The solution's integration is good."
"It has allowed fast daily loads and analysis of millions of rows of data, which eventually moved to near real-time."
"It handles high volumes of data very well."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"The cloning functionality has been the most valuable. I have been able to completely copy databases. The data sharing concept is also useful. As compared to, for example, SAP, Snowflake is a lot more open, and it allows a lot more connectivity for other providers than an SAP ecosystem."
"The technical support is pretty good, particularly if you are a more technical user."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"The pricing is reasonable and matches the rest of the market."
"I would like the tool to support different operating systems."
"The reporting for certain types of data needs to be improved."
"We'd like to see it be a bit more compatible with other solutions."
"I would like to see better visualization features."
"The only issue with the product is that the process is very slow when we have a huge amount of data."
"I think that the error messages need to be made more specific."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"This solution would be improved with an option for in-memory data analysis."
"It needs a bit more rigor and governance, which is something you don't get with newer tools. This makes it less enterprise scalable. Its governance and structure can be enhanced, which would really be valuable. I would like to see some kind of prebuilt functionality in terms of having almost like a pre-built data warehouse. A functionality for generating automated kind of pieces would be good."
"Snowflake can improve its machine learning and AI capabilities."
"The solution could improve the user interface and add functionality to the system."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"Snowflake has to improve their spatial parts since it doesn't have much in terms of geo-spatial queries."
"Some SQL language functions could be included."
"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."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while Snowflake is ranked 1st in Data Warehouse with 92 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while Snowflake 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 writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". 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.