No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Fabric vs Snowflake comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Microsoft Fabric
Average Rating
7.6
Number of Reviews
3
Ranking in other categories
Data Management Platforms (DMP) (9th)
Snowflake
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
108
Ranking in other categories
Data Warehouse (1st), Cloud Data Warehouse (1st), AI Synthetic Data (1st), Database Management Systems (DBMS) (4th), AI Software Development (10th)
 

Featured Reviews

Ankush-Singh - PeerSpot reviewer
Lead Software Engineer at Momentus
Unified analytics platform has simplified complex dashboards and supported secure data pipelines
One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading. If you are dealing with real-time databases or data, you need to work with Event Hub and event streaming, but for normal batch processing, you can usually go ahead with the SQL warehouse or the data lakehouse. I recommend that Microsoft unify these processes, so using one source can meet both requirements. If I am working with real-time data and batched data, I should not have to manage two separate systems; instead of creating an Event Hub and a lakehouse, users could simply manage one house to handle both real-time analysis and batch processing, making it simpler and more user-friendly from both business and development perspectives.
SunilPatil1 - PeerSpot reviewer
Asset Builder at Genpact - Headstrong
Have prioritized security while managing multi-agent data migration and cloud adoption
We utilize Time Travel with Snowflake because this is a very useful feature. Everyone finds it crucial because in conventional data platforms, it's very difficult to handle these kinds of things. This feature is essential, though I don't have the use cases currently; it is just there for implementation. Regarding Snowflake's automated scaling and suspension features, this auto-scaling is very significant. We had a comparison with Databricks and Snowflake a few months back, and this auto-scaling takes an edge within Snowflake; that's what our observation reflects.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The best feature Microsoft Fabric offers in my experience is the Dataflow."
"The most valuable and useful feature I have found in Microsoft Fabric is data consistency, which is the top thing."
"The features and capabilities of Microsoft Fabric that I have found most useful include it being a uniform platform."
"Great scalability and near zero maintenance."
"The product does a lot of wonderful stuff that a lot of these companies want to do without too much effort."
"Snowflake's most valuable features are data enrichment and flattening."
"The most efficient way for real-time dashboards or analytical business intelligence reports to be sent to the customer."
"Snowflake is ahead of the competitors because it's completely automatic and hands-off in terms of maintenance."
"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."
"From a user's standpoint, it is a good product."
"The overall ecosystem was easy to manage. Given that we weren't a very highly technical group, it was preferable to other things we looked at because it could do all of the cloud tunings. It can tune your data warehouse to an appropriate size for controlled billing, resume and sleep functions, and all such things. It was much more simple than doing native Azure or AWS development. It was stable, and their support was also perfect. It was also very easy to deploy. It was one of those rare times where they did exactly what they said they could do."
 

Cons

"One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading."
"In my experience, Microsoft Fabric is not stable."
"I think the Copilot usage in Microsoft Fabric can be improved."
"We would like to be able to do modeling with Snowflake. It should support statistical modeling."
"It would benefit from an administration that allows you to be aware of your credit consumption once you have the service so that you may be sure how many credits you are consuming when you use the platform and to make sure that you are making the most efficient use of these resources. In other words, to improve their interface so that you may monitor the consumption of your credits on Cloud."
"An additional feature I'd like to see is called materialized views, which can speed up some run times. I'd like it to be able to be used where you can have multiple tables inside them; materialized view. That would be nice. As well as being able to run cursors, to be able to do some bulk updates and some more advanced querying, table building on the fly."
"It's difficult to know how to size everything correctly."
"I am still in the learning stage. It has good security, but it can always be more secure."
"Some SQL language functions could be included."
"There are some functions in the SQL language in other products which are not yet included in Snowflake's SQL."
"It doesn't enforce typical relational database constraints. Quite expensive."
 

Pricing and Cost Advice

Information not available
"The pricing part is based on the computing and storage. The costs are different and then there are services costs as well."
"We use Snowflake pretty heavily. We pay a significant amount of money for the tool. I'd say we pay $300k to $400K every year."
"It is pay-as-you-go. Its cost is in the medium range."
"On average, with the number of queries that we run, we pay approximately $200 USD per month."
"We're based on credits. So, we're paying four and a half dollars of credit. There are no additional costs. I would rate it a two out of five in terms of pricing."
"Comparing Snowflake to on-prem options such as Oracle or SAP, it seemed more cost-effective."
"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."
"Pricing is based on usage. It is the most expensive of our data tools."
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
919,586 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Healthcare Company
14%
Outsourcing Company
13%
Manufacturing Company
11%
Construction Company
9%
Financial Services Firm
17%
Manufacturing Company
11%
Outsourcing Company
9%
Comms Service Provider
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business31
Midsize Enterprise20
Large Enterprise61
 

Questions from the Community

What needs improvement with Microsoft Fabric?
I think Microsoft Fabric can be improved, but I feel that everything is adequate. Everything is acceptable regarding the needed improvements.
What is your primary use case for Microsoft Fabric?
My main use case for Microsoft Fabric is data engineering. A specific example of something my team has used Microsoft Fabric for is to collect information from many sources and put it in the data w...
What advice do you have for others considering Microsoft Fabric?
My advice to others looking into using Microsoft Fabric is that it is a good solution. I heard from the cloud infrastructure team about this product. I do not have any additional thoughts about Mic...
What is your experience regarding pricing and costs for Snowflake?
We find the metering and billing experience for Snowflake to be expensive because there are many limitations to what it can do. When we compared performance-wise and cost-wise to Bedrock for some o...
What needs improvement with Snowflake?
Lessons learned about our main use case or how Snowflake performed in those areas include that the sales representatives do not really understand the product, and that the solutions consultants bas...
What is your primary use case for Snowflake?
Our main use case for Snowflake was to ingest data, use it for search, analytics, and data sharing with our customers; however, in reality, those use cases did not work. When it came to our challen...
 

Also Known As

No data available
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Information Not Available
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Palantir, Informatica, Databricks and others in Data Management Platforms (DMP). Updated: October 2026.
919,586 professionals have used our research since 2012.