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

Azure Data Factory vs Snowflake Analytics comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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
5.3
Azure Data Factory centralizes data, cuts costs, boosts efficiency, enhances client satisfaction, and delivers a 20-30% return.
Sentiment score
5.6
Users experience mixed ROI with Snowflake; it often improves operational efficiency, time savings, and cost control.
Our stakeholders and clients have expressed satisfaction with Azure Data Factory's efficiency and cost-effectiveness.
Data Engineer at Vthinktechnologies
Snowflake Analytics has positively impacted our organization by saving about eight to ten hours per week, which we can use for advanced analytics and automation tasks.
Junior Data engineer at a tech vendor with 10,001+ employees
 

Customer Service

Sentiment score
6.2
Azure Data Factory support is generally proficient and accessible, though response times and costs can vary for dedicated support.
Sentiment score
6.9
Snowflake Analytics support is often responsive and competent, but accessibility issues exist for non-major partners, despite strong community resources.
On a scale of one to ten, I would rate the technical support as nine.
Senior Consultant Oracle Technologies at a tech vendor with 10,001+ employees
The technical support from Microsoft is rated an eight out of ten.
Chief Analytics Officer at Idiro Analytics
The technical support is responsive and helpful
Sr. Technical Architect at Hexaware Technologies Limited
The Snowflake Analytics documentation is excellent.
Lead Analytics Consultant at a outsourcing company with 51-200 employees
Recently we had a two-day session where the Snowflake Analytics team provided a demo on Cortex AI and its features.
Associate Principal Engineer at Nagarro
The technical support for Snowflake Analytics is excellent based on what I have heard from others.
Data Governance Architect at Sterlite Technologies Ltd
 

Scalability Issues

Sentiment score
7.3
Azure Data Factory is scalable and flexible but sometimes requires support for quotas and improvements for broader scalability.
Sentiment score
7.7
Snowflake Analytics offers exceptional scalability through auto-scaling, cloud integration, and efficient resource management, ideal for handling large data volumes.
Azure Data Factory is highly scalable.
Chief Analytics Officer at Idiro Analytics
I did not experience scalability issues.
Principal Data Engineer at Oracle
Storage is unlimited because they use S3 if it is AWS, so storage has no limit.
Senior Software Architect at USEReady
It supports both horizontal and vertical scaling effectively.
Data Governance Architect at Sterlite Technologies Ltd
Maintaining security and data governance becomes easier with an entire data lake in place, and the scalability improves performance.
Associate Principal Engineer at Nagarro
 

Stability Issues

Sentiment score
7.8
Azure Data Factory is highly rated for stability, though performance varies with setup, data volume, and resource allocation.
Sentiment score
8.4
Snowflake Analytics is highly stable, supported by major cloud providers, with strong performance and minimal technical issues reported.
The solution has a high level of stability, roughly a nine out of ten.
Chief Analytics Officer at Idiro Analytics
It gives me the accurate result.
Test Engineer at Happiest Minds Technologies
I have been using Azure Data Factory for a very long time, and I did not find too many issues.
Principal Data Engineer at Oracle
Snowflake Analytics has been stable and reliable in my experience.
Associate Principal Engineer at Nagarro
Snowflake Analytics is very stable; I have never experienced any crash downs or server issues.
Junior Data engineer at a tech vendor with 10,001+ employees
Snowflake Analytics is stable, scoring around eight point five to nine out of ten.
Data Governance Architect at Sterlite Technologies Ltd
 

Room For Improvement

Azure Data Factory needs better setup, connectivity, documentation, support, performance, and UI for enhanced functionality and user experience.
Snowflake Analytics struggles with data migration, integration, performance, cost issues, and needs better UI, job scheduling, and AWS support.
The ability to handle the largest volumes of data is another concern; if I have to manage more than one terabyte of data every day, I am not comfortable dealing with Azure Data Factory and had to switch to Oracle Data Integrators (ODI) because it lacks performance features.
Senior Consultant Oracle Technologies at a tech vendor with 10,001+ employees
If I am making a pipeline, it should give me suggestions, such as which activity should be used, so that I don't have to remember each activity.
Test Engineer at Happiest Minds Technologies
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
Chief Analytics Officer at Idiro Analytics
AIML-based SQL prompt and query generation could be an area for enhancement.
Senior Software Architect at USEReady
If it offered flexibility similar to Oracle and supported more heterogeneous data sources and database connectivity, it would be even better.
Data Governance Architect at Sterlite Technologies Ltd
I would prefer Snowflake Analytics to improve their support response times, as sometimes the responses we receive are not very prompt and ticket assignments may not be timely.
Associate Principal Engineer at Nagarro
 

Setup Cost

Azure Data Factory's pricing is competitive but complex, requiring careful monitoring to manage costs for high data usage.
Snowflake Analytics uses a pay-as-you-go model, emphasizing strategic design to manage costs, often seen as competitively priced.
The pricing is cost-effective.
Chief Analytics Officer at Idiro Analytics
It is considered cost-effective.
Sr. Technical Architect at Hexaware Technologies Limited
Snowflake charges per query, which amounts to a very minor cost, such as $0.015 per query.
BI Developer at DivVerse LLC
Snowflake is better and cheaper than Redshift and other cloud warehousing systems.
Senior Software Architect at USEReady
Snowflake Analytics is quite economical.
Data Governance Architect at Sterlite Technologies Ltd
 

Valuable Features

Azure Data Factory excels in performance, ease of use, scalability, and integration, making it highly valued for ETL processes.
Snowflake Analytics provides scalable, secure, and user-friendly analytics with cloud integration, supporting diverse data needs and flexible data sharing.
It connects to different sources out-of-the-box, making integration much easier.
Sr. Technical Architect at Hexaware Technologies Limited
The platform excels in handling major datasets, particularly when working with Power BI for reporting purposes.
Data Engineer at Vthinktechnologies
Regarding the integration feature in Azure Data Factory, the integration part is excellent; we have major source connectors, so we can integrate the data from different data sources and also perform basic transformation while transforming, which is a great feature in Azure Data Factory.
Director at a computer software company with 1,001-5,000 employees
Running a considerable query on Microsoft SQL Server may take up to thirty minutes or an hour, while Snowflake executes the same query in less than three minutes.
BI Developer at DivVerse LLC
Snowflake Analytics supports data security with a single sign-on feature and complies with framework regulations, which is highly beneficial.
Data Governance Architect at Sterlite Technologies Ltd
Previously, we faced issues with slow queries due to traditional systems, but within Snowflake, we can assign separate virtual warehouses for reporting as well as data processing, ensuring that it does not impact tool performance and does not delay reporting to business users.
Junior Data engineer at a tech vendor with 10,001+ employees
 

Categories and Ranking

Azure Data Factory
Ranking in Cloud Data Warehouse
7th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
97
Ranking in other categories
Data Integration (5th)
Snowflake Analytics
Ranking in Cloud Data Warehouse
11th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
44
Ranking in other categories
Web Analytics (2nd)
 

Mindshare comparison

As of September 2026, in the Cloud Data Warehouse category, the mindshare of Azure Data Factory is 5.2%, down from 6.8% compared to the previous year. The mindshare of Snowflake Analytics is 3.4%, up from 1.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse Mindshare Distribution
ProductMindshare (%)
Azure Data Factory5.2%
Snowflake Analytics3.4%
Other91.4%
Cloud Data Warehouse
 

Featured Reviews

Kunal Das - PeerSpot reviewer
Test Engineer at Happiest Minds Technologies
Drag-and-drop pipelines have saved days of work and now automate data movement and backfilling
If the AI features were more improved so that I don't have to provide each and every detail, Azure Data Factory could be improved in a much better way by improving the AI features. For example, if I want to fetch any data from a raw source, I need to provide each and every detail. But if I am just uploading my raw data and if AI will sync with that data, it can analyze that data and give me proper suggestions on how that should be done in a proper way. Automatic suggestions could improve in a much better way. As I have mentioned, the AI features as well as more drag-and-drop activities could be improved. If I am making a pipeline, it should give me suggestions, such as which activity should be used, so that I don't have to remember each activity. If I have used one activity, I shouldn't have to remember what activity should I use next. It should give auto-suggestions. That is why I have given a nine out of 10. Currently, I don't know about its governance and security, but in view of its improvement, I think Azure Data Factory should improve in these areas. As I already mentioned, the AI features should be improved. Also, the auto-suggestion features should also improve.
Garima Goel - PeerSpot reviewer
Associate Principal Engineer at Nagarro
Have created secure cloud-based data lakes and improved real-time data processing using integrated AI features
There are many capabilities which Snowflake Analytics offers that I find valuable, such as the storage and compute engine that allows working with any cloud system such as AWS or Azure, alongside its efficiencies in storage computation and cost-effectiveness, which saves money compared to on-premise systems. We also have features such as pre-cached results, Time Travel, and fail-safe, which are very useful for restoring data if deleted accidentally, and the streams and data pipes that facilitate real-time ingestion are great features as well. Snowflake Analytics offers multiple new connectors, allowing me to connect it with Kafka, and with Snowpark, I can work with any programming language such as Python, Java, or Scala for data processing and analysis. The data sharing feature offered by Snowflake Analytics is good because it allows sharing specific sets of data to end customers or users from different Snowflake Analytics accounts without exposing the entire dataset for data security reasons. Snowflake Analytics' support for machine learning models and real-time insights has enhanced significantly. Originally, it wasn't strong in AI/ML, but now it has multiple models and forecasting capabilities, providing good competition to tools such as Databricks and Spark. In BI, I have worked majorly with Microsoft Power BI, and the integration with Snowflake Analytics is very easy. The way we integrate Snowflake Analytics with other on-premise systems just requires the warehouse details, username, passwords, and the account name, along with multiple options such as client ID and credentials for logging in and creating a session. The end-to-end encryption provided by Snowflake Analytics is very important because, in my previous firm, working in finance and investment management, data encryption is necessary due to the sensitive nature of customer data and the involvement of people's money. It's crucial to have encryption in transit and at rest, along with data masking features which Snowflake Analytics offers.
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
913,683 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
11%
Manufacturing Company
9%
Computer Software Company
8%
Construction Company
7%
Construction Company
17%
Outsourcing Company
14%
Financial Services Firm
9%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business31
Midsize Enterprise21
Large Enterprise64
By reviewers
Company SizeCount
Small Business11
Midsize Enterprise13
Large Enterprise23
 

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 is your experience regarding pricing and costs for Snowflake Analytics?
The pricing for Snowflake Analytics is reasonable, but as I am not part of the management team, I am not certain about our organization's exact costs. Overall, the return on investment for this too...
What needs improvement with Snowflake Analytics?
One improvement Snowflake Analytics could benefit from is in cost, particularly during peak hours. Sometimes, due to its automatic scalability, we think it has scaled up, but it does not always hap...
What is your primary use case for Snowflake Analytics?
I am using Snowflake Analytics because we are already using Snowflake for data engineering and data warehousing tasks, and we are using it for analytics as well as business intelligence reporting. ...
 

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
Lionsgate, Adobe, Sony, Capital One, Akamai, Deliveroo, Snagajob, Logitech, University of Notre Dame, Runkeeper
Find out what your peers are saying about Azure Data Factory vs. Snowflake Analytics and other solutions. Updated: September 2026.
913,683 professionals have used our research since 2012.