We performed a comparison between Microsoft Analytics Platform System 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."The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"Helps our customers to discover trends, which provides useful information based on their business."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"I like that it's integrated with other Azure products."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"It is closely integrated with other products in the MS portfolio."
"This is a well-integrated solution and that integration empowers results."
"The most valuable features of Snowflake are that you have to pay per usage, and you don't have to worry about the maintenance of the data warehouse because it is on the cloud."
"Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake."
"The initial setup is very simple."
"The solution is easy to use."
"The initial setup is straightforward. You just need to follow the documentation."
"The tool's performance is good. I think it's the best in the game right now. It usually charges per query. For example, if you run a SQL query on Snowflake with the same number of data records, it would take less than half the time compared to running it on Microsoft. It has good documentation. You can pick up Snowflake if you have previous knowledge of SQL."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"Snowflake is faster than on-premise systems and allows for variable compute power based on need."
"Hybrid environments are complex to manage."
"The pricing model needs to be improved."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Microsoft Analytics Platform System could have better support."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"From the documentation, the black box is not very descriptive. Snowflake does not reveal how exactly the data is processed or sourced."
"Product activation queries can't be changed while executing."
"The solution needs more connectors."
"Some SQL language functions could be included."
"Its pricing or affordability is one of the big challenges. Pricing was the only thing that we didn't like about Snowflake. In terms of technical features, it is a complete solution."
"Snowflake needs transparency over costs and pricing."
"The complexity of the initial setup of Snowflake depends on the use case. However, Snowflake itself, we don't set it up. The difficulty comes from the ingestion patterns, depending on what data I'm putting in, what kind of enrichment, and what additional value we have to add. However, it does tend to get complex because we have a lot of semi-structured data which we need to handle in Snowflake. There have been some challenges."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 18th in Data Warehouse with 9 reviews while Snowflake is ranked 1st in Data Warehouse with 94 reviews. Microsoft Analytics Platform System is rated 6.6, while Snowflake is rated 8.4. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". 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 Analytics Platform System is most compared with Microsoft Azure Synapse Analytics and IBM Netezza Performance Server, whereas Snowflake is most compared with BigQuery, Azure Data Factory, Teradata, Vertica and AWS Lake Formation. See our Microsoft Analytics Platform System 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.