Compare Microsoft Analytics Platform System vs. Snowflake

Cancel
You must select at least 2 products to compare!
Top Review
Find out what your peers are saying about Microsoft Analytics Platform System vs. Snowflake and other solutions. Updated: September 2021.
535,544 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
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model.""The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics.""I like that it's integrated with other Azure products.""This is a well-integrated solution and that integration empowers results."

More Microsoft Analytics Platform System Pros »

"The most valuable features are the clustering, LS50, being able to change the size, the pay per use feature, the flexibility with many different sources and analytic applications.""They separate compute and storage. You can scale storage independently of the computer, or you can scale computing independently of storage. If you need to buy more computer parts you can add new virtual warehouses in Snowflake. Similarly, if you need more storage, you take more storage. It's most scalable in the database essentially; typically you don't have this scalability independence on-premises.""The initial setup is straightforward. You just need to follow the documentation.""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.""It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL.""I like the idea that you can assign roles and responsibilities, limiting access to data.""The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes.""The snapshot feature is good, the rollback feature is good and the interface is user-friendly."

More Snowflake Pros »

Cons
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps.""Functionality needs to be more up-to-date with competing products.""The pricing model needs to be improved.""Machine learning and artificial intelligence capabilities need to be more friendly for beginning users.""I think the biggest problem with the product is that it does a data ingest model, which is very expensive.""Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."

More Microsoft Analytics Platform System Cons »

"Support needs improvement, as it can take several days before you get some initial support.""The solution should offer an on-premises version also. We have some requirements where we would prefer to use it as a template.""The solution could improve the user interface and add functionality to the system.""Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway.""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.""If you go with one cloud provider, you can't switch.""Availability is a problem.""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."

More Snowflake Cons »

Pricing and Cost Advice
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership.""Users have to pay extra for premium-level technical support.""We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."

More Microsoft Analytics Platform System Pricing and Cost Advice »

"Pricing can be confusing for customers.""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.""You pay based on the data that you are storing in the data warehouse and there are no maintenance costs.""It is not cheap.""The pricing for Snowflake is competitive.""On average, with the number of queries that we run, we pay approximately $200 USD per month.""Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month.""The price of Snowflake is very reasonable."

More Snowflake Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
535,544 professionals have used our research since 2012.
Questions from the Community
Ask a question

Earn 20 points

Top Answer: Its performance is most valuable. As compared to SQL Server, we are able to see a significant improvement in performance with Snowflake.
Top Answer: It is little more costly but it has great features to keep the control on pricing if utilised properly like different warehouse sizes, caching, auto-suspend of warehouses and some more.
Top Answer: There are a lot of features that they need to come up with. A lot of functions are missing in Snowflake, so we have to find a workaround for those. For example, OUTER APPLY is a basic function in SQL… more »
Ranking
15th
out of 30 in Data Warehouse
Views
964
Comparisons
606
Reviews
4
Average Words per Review
839
Rating
6.3
1st
out of 30 in Data Warehouse
Views
35,441
Comparisons
25,650
Reviews
41
Average Words per Review
586
Rating
8.4
Comparisons
Also Known As
Microsoft APS, MS Analytics Platform System
Snowflake Computing
Learn More
Overview
The Microsoft Analytics Platform System can meet the demands of your evolving data warehouse environment with its scale-out, massively parallel processing integrated system supporting hybrid data warehouse scenarios. It provides the ability to query across relational and non-relational data by leveraging Microsoft PolyBase and industry-leading big data technologies. It offers the lowest price per terabyte for large data warehouse workloads.

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 Analytics Platform System
Learn more about Snowflake
Sample Customers
Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Top Industries
VISITORS READING REVIEWS
Comms Service Provider23%
Computer Software Company18%
Insurance Company6%
Media Company6%
REVIEWERS
Computer Software Company41%
Financial Services Firm14%
Manufacturing Company9%
Wholesaler/Distributor9%
VISITORS READING REVIEWS
Computer Software Company29%
Comms Service Provider15%
Financial Services Firm8%
Insurance Company5%
Company Size
REVIEWERS
Small Business38%
Large Enterprise63%
REVIEWERS
Small Business26%
Midsize Enterprise24%
Large Enterprise50%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise15%
Large Enterprise70%
Find out what your peers are saying about Microsoft Analytics Platform System vs. Snowflake and other solutions. Updated: September 2021.
535,544 professionals have used our research since 2012.

Microsoft Analytics Platform System is ranked 15th in Data Warehouse with 4 reviews while Snowflake is ranked 1st in Data Warehouse with 41 reviews. Microsoft Analytics Platform System is rated 6.2, while Snowflake is rated 8.4. The top reviewer of Microsoft Analytics Platform System writes "Has unique functionality for advanced analytics but could use enhancement in machine learning and AI features". On the other hand, the top reviewer of Snowflake writes "Fast, convenient and requires almost no administration". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Apache Hadoop, Oracle Exadata and IBM Netezza Performance Server, whereas Snowflake is most compared with Microsoft Azure Synapse Analytics, Amazon Redshift, Firebolt, Vertica and Teradata. See our Microsoft Analytics Platform System vs. Snowflake report.

See our list of best 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.