Try our new research platform with insights from 80,000+ expert users

Azure Data Factory vs Snowflake comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

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

ROI

Sentiment score
7.1
Azure Data Factory offers significant time, effort, and infrastructure savings, enhancing data analysis and decision-making capabilities.
Sentiment score
6.8
Snowflake offers improved data management and security, with varied ROI perceptions, yet users recognize added value and efficiency.
 

Customer Service

Sentiment score
6.5
Azure Data Factory support is praised for responsiveness, though some report delays; satisfaction varies with Microsoft partnerships.
Sentiment score
7.3
Snowflake's customer service is praised for expertise and responsiveness, though some users experience delays due to time zone differences.
The technical support from Microsoft is rated an eight out of ten.
The technical support is responsive and helpful
The technical support for Azure Data Factory is generally acceptable.
I received great support in migrating data to Snowflake, with quick responses and innovative solutions.
 

Scalability Issues

Sentiment score
7.5
Azure Data Factory scales efficiently, managing large datasets for enterprises, though users note cost and integration limitations.
Sentiment score
7.8
Snowflake offers seamless and cost-effective scalability with independent compute and storage, enabling efficient resource management for large data volumes.
Azure Data Factory is highly scalable.
Snowflake is very scalable and has a dedicated team constantly improving the product.
 

Stability Issues

Sentiment score
7.8
Azure Data Factory is highly rated for stability, scalability, and performance, despite occasional minor issues with larger data volumes.
Sentiment score
8.2
Snowflake impresses users with remarkable stability, reliability, and performance, ensuring efficient data management with minimal disruptions and maintenance.
The solution has a high level of stability, roughly a nine out of ten.
Snowflake is very stable, especially when used with AWS.
 

Room For Improvement

Azure Data Factory requires improvements in integration, pricing, documentation, UI, monitoring, processing, and debugging for enhanced user experience.
Snowflake users desire improvements in spatial components, analytics, pricing, support, data protection, integration, and advanced AI features.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
Sometimes, the compute fails to process data if there is a heavy load suddenly, and it doesn't scale up automatically.
There is a problem with the integration with third-party solutions, particularly with SAP.
Cost reduction is one area I would like Snowflake to improve.
 

Setup Cost

Azure Data Factory offers competitive, flexible pay-as-you-go pricing; costs vary by data volume and use of additional services.
Snowflake's pricing is pay-as-you-go with competitive storage, higher compute costs, and discounts for bulk purchases, requiring usage optimization.
The pricing is cost-effective.
It is considered cost-effective.
Snowflake's pricing is on the higher side.
 

Valuable Features

Azure Data Factory enables easy data integration, management, and transformation with over 100 connectors, supporting ETL and automation efficiently.
Snowflake is praised for its scalability, flexibility, performance, cost-effectiveness, and seamless integration with popular cloud platforms.
It connects to different sources out-of-the-box, making integration much easier.
The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses.
 

Categories and Ranking

Azure Data Factory
Ranking in Cloud Data Warehouse
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Integration (1st)
Snowflake
Ranking in Cloud Data Warehouse
1st
Average Rating
8.4
Reviews Sentiment
7.2
Number of Reviews
99
Ranking in other categories
Data Warehouse (1st), AI Synthetic Data (3rd)
 

Mindshare comparison

As of February 2025, in the Cloud Data Warehouse category, the mindshare of Azure Data Factory is 9.1%, down from 10.2% compared to the previous year. The mindshare of Snowflake is 22.0%, down from 22.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Joy Maitra - PeerSpot reviewer
Facilitates seamless data pipeline creation with good analytics and and thorough monitoring
Azure Data Factory is a low code, no code platform, which is helpful. It provides many prebuilt functionalities that assist in building data pipelines. Also, it facilitates easy transformation with all required functionalities for analytics. Furthermore, it connects to different sources out-of-the-box, making integration much easier. The monitoring is very thorough, though a more readable version would be appreciable.
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
838,640 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Computer Software Company
12%
Manufacturing Company
9%
Healthcare Company
7%
Educational Organization
38%
Financial Services Firm
12%
Computer Software Company
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How do you select the right cloud ETL tool?
AWS Glue and Azure Data factory for ELT best performance cloud services.
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
Snowflake's pricing is on the higher side, rated as eight out of ten. If there were ways to reduce costs, it would be a positive improvement.
What needs improvement with Snowflake?
Cost reduction is one area I would like Snowflake to improve. The product is not very cheap, and a reduction in costs would be appreciated.
 

Also Known As

No data available
Snowflake Computing
 

Overview

 

Sample Customers

1. Adobe 2. BMW 3. Coca-Cola 4. General Electric 5. Johnson & Johnson 6. LinkedIn 7. Mastercard 8. Nestle 9. Pfizer 10. Samsung 11. Siemens 12. Toyota 13. Unilever 14. Verizon 15. Walmart 16. Accenture 17. American Express 18. AT&T 19. Bank of America 20. Cisco 21. Deloitte 22. ExxonMobil 23. Ford 24. General Motors 25. IBM 26. JPMorgan Chase 27. Microsoft (Azure Data Factory is developed by Microsoft) 28. Oracle 29. Procter & Gamble 30. Salesforce 31. Shell 32. Visa
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Azure Data Factory vs. Snowflake and other solutions. Updated: January 2025.
838,640 professionals have used our research since 2012.