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."I like that it's integrated with other Azure products."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"Helps our customers to discover trends, which provides useful information based on their business."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"This is a well-integrated solution and that integration empowers results."
"It is closely integrated with other products in the MS portfolio."
"The Mbps they have established is quite a bit faster than any other data warehouse."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"The solution is very easy to use."
"The distributed architecture of Snowflake has the capacity to process huge datasets faster and allows us to scale up and down according to our needs."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"Once you have finished your designs they can be easily imported to Snowflake and the information can be readily accessed without an IT expert."
"The syntax is advanced which reduces the time to write code."
"It's ultra-fast at handling queries, which is what we find very convenient."
"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."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Hybrid environments are complex to manage."
"The pricing model needs to be improved."
"Functionality needs to be more up-to-date with competing products."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"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."
"If they could bring in some tools for data integration, it would be really great."
"To ensure the proper functioning of Snowflake as an MDS, it relies heavily on other partner tools."
"Currently, Snowflake doesn't support unstructured data."
"We would like to see more security including more masking and more encryption at the database level."
"It would be better if they had a data profile tool that tells me where the gaps are in my time series data."
"If you go with one cloud provider, you can't switch."
"The cost efficiency and monitoring of this solution could be improved. It's easy to spend a lot on Snowflake and it does offer monitoring tools but they're pretty basic."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Snowflake is ranked 1st in Data Warehouse with 92 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, Teradata 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.