

Snowflake and Azure Data Factory are competitors in cloud data management and integration solutions. While Snowflake is favored for its data management and warehouse capabilities, Azure Data Factory leads with its integration features.
Features: Snowflake excels in path applications, time travel retrieval, and scalability. It offers ease of management and zero-copy cloning, which streamlines data operations. Azure Data Factory stands out with its intuitive data flow operations, effective orchestration, and ability to support various data sources, particularly in hybrid scenarios. Its integration with other Azure services enhances its versatility.
Room for Improvement: Snowflake users suggest improvements in AI tool integration, better handling of unstructured data, and reduced costs. Enhanced external tool integration and user experience with pipelines are also needed. Azure Data Factory could improve performance during heavy loads, provide better monitoring capabilities, and enhance integration with SAP and other third-party solutions. Easier use and clearer pricing are also desired.
Ease of Deployment and Customer Service: Snowflake is predominantly cloud-based with responsive customer support, but lacks some service-level agreements. Azure Data Factory offers hybrid cloud deployments, and while it generally provides helpful customer service, its technical support documentation and real-time assistance could be improved.
Pricing and ROI: Snowflake uses a credit-based pricing model which can be cost-effective, but unpredictable. It delivers strong ROI. Azure Data Factory has a pay-as-you-go model seen as cost-effective, though the usage-based pricing sometimes makes cost prediction challenging. Both solutions are seen as solid investments, with Azure Data Factory being particularly effective in cutting down on data integration expenses.
Our stakeholders and clients have expressed satisfaction with Azure Data Factory's efficiency and cost-effectiveness.
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.
I am satisfied with the work of technical support from Snowflake; they are responsive and helpful.
The technical support from Snowflake is very good, nice, and efficient.
Azure Data Factory is highly scalable.
Snowflake is very scalable and has a dedicated team constantly improving the product.
The billing doubles with size increase, but processing does not necessarily speed up accordingly.
Recently, Snowflake has introduced streaming capabilities, real-time and dynamic tables, along with various connectors.
The solution has a high level of stability, roughly a nine out of ten.
Snowflake is very stable, especially when used with AWS.
Snowflake as a SaaS offering means that maintenance isn't an issue for me.
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.
Enhancements in user experience for data observability and quality checks would be beneficial, as these tasks currently require SQL coding, which might be challenging for some users.
What things you are going with to ask the support and how we manage the relationship matters a lot.
If more connectors were brought in and more visibility features were added, particularly around cost tracking in the FinOps area, it would be beneficial.
The pricing is cost-effective.
It is considered cost-effective.
Snowflake's pricing is on the higher side.
Snowflake lacks transparency in estimating resource usage.
It connects to different sources out-of-the-box, making integration much easier.
The platform excels in handling major datasets, particularly when working with Power BI for reporting purposes.
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.
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.
I have used the Snowflake Zero-Copy Cloning feature in the past while prototyping data in lower environments. This feature is helpful as it saves a lot of time during the data replication process.
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses.
| Product | Market Share (%) |
|---|---|
| Snowflake | 15.9% |
| Azure Data Factory | 5.7% |
| Other | 78.4% |


| Company Size | Count |
|---|---|
| Small Business | 31 |
| Midsize Enterprise | 19 |
| Large Enterprise | 57 |
| Company Size | Count |
|---|---|
| Small Business | 29 |
| Midsize Enterprise | 20 |
| Large Enterprise | 58 |
Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.
Snowflake provides a modern data warehousing solution with features designed for seamless integration, scalability, and consumption-based pricing. It handles large datasets efficiently, making it a market leader for businesses migrating to the cloud.
Snowflake offers a flexible architecture that separates storage and compute resources, supporting efficient ETL jobs. Known for scalability and ease of use, it features built-in time zone conversion and robust data sharing capabilities. Its enhanced security, performance, and ability to handle semi-structured data are notable. Users suggest improvements in UI, pricing, on-premises integration, and data science functions, while calling for better transaction performance and machine learning capabilities. Users benefit from effective SQL querying, real-time analytics, and sharing options, supporting comprehensive data analysis with tools like Tableau and Power BI.
What are Snowflake's Key Features?
What Benefits Should You Look for?
In industries like finance, healthcare, and retail, Snowflake's flexible data warehousing and analytics capabilities facilitate cloud migration, streamline data storage, and allow organizations to consolidate data from multiple sources for advanced insights and AI-driven strategies. Its integration with analytics tools supports comprehensive data analysis and reporting tasks.
We monitor all Cloud 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.