We compared Snowflake and Azure Data Factory based on our user's reviews in several parameters.
Based on user reviews, Snowflake is praised for its high performance, scalability, and ease of use, while Azure Data Factory is appreciated for its seamless integration with data sources and robust monitoring capabilities. Snowflake's customer service and support received positive feedback, while Azure Data Factory is praised for its prompt assistance and responsiveness. Users find Snowflake's pricing and licensing terms flexible and reasonable compared to similar solutions, while Azure Data Factory is valued for its fair pricing and straightforward setup process. Both platforms have been reported to provide a positive ROI, with Snowflake benefiting from enhancements to improve user experience and functionality, and Azure Data Factory needing improvements in user interface, documentation, resource allocation, data integration capabilities, performance, stability, and debugging processes.
Features: Snowflake's valuable features include high performance, scalability, and ease of use. Users appreciate its efficient handling of large volumes of data and its user-friendly interface. On the other hand, Azure Data Factory is praised for its seamless integration with various data sources, ability to orchestrate complex data workflows, and robust monitoring capabilities.
Pricing and ROI: Snowflake and Azure Data Factory both receive positive feedback regarding their pricing, setup process, and licensing options. Users find Snowflake's setup process relatively uncomplicated, while Azure Data Factory's setup is described as seamless. Additionally, both products offer flexible and adaptable licensing options to meet various business needs., Snowflake: User reviews indicate positive ROI. Azure Data Factory: User feedback shows positive ROI with cost savings, improved productivity, streamlined data integration and migration, scalability, flexibility, and robust functionality.
Room for Improvement: Snowflake could benefit from enhancements to enhance user experience and functionality, while Azure Data Factory has areas for improvement in its user interface, documentation, resource allocation, data integration capabilities, performance, stability, and debugging process.
Deployment and customer support: Based on user feedback, Snowflake and Azure Data Factory have differences in the duration required for establishing a new tech solution. While Snowflake emphasizes the importance of considering separate deployment and setup phases, Azure Data Factory users reported varying timeframes, with some taking three months for deployment and others only a week for setup., Snowflake's customer service has been positively received by users, particularly for the expertise and effectiveness of their support team. On the other hand, Azure Data Factory's customer service has been consistently praised for their prompt assistance and knowledgeable staff.
The summary above is based on 84 interviews we conducted recently with Snowflake and Azure Data Factory users. To access the review's full transcripts, download our report.
"It's cloud-based, allowing multiple users to easily access the solution from the office or remote locations. I like that we can set up the security protocols for IP addresses, like allow lists. It's a pretty user-friendly product as well. The interface and build environment where you create pipelines are easy to use. It's straightforward to manage the digital transformation pipelines we build."
"Its integrability with the rest of the activities on Azure is most valuable."
"The solution includes a feature that increases the number of processors used which makes it very powerful and adds to the scalability."
"The most important feature is that it can help you do the multi-threading concepts."
"The most valuable feature of this solution would be ease of use."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"From what we have seen so far, the solution seems very stable."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"It has great flexibility whenever we are loading data and performs ELT (extract, load, transform) techniques instead of ETL."
"Its performance is a big advantage. When you run a query, its performance is very good. The inbound and outbound share features are also very useful for sharing a particular database. By using these features, you can allow others to access the Snowflake database and query it, which is another advantage of this solution. It has good security, and we can easily integrate it. We can connect it with multiple source systems."
"The technical support on offer is excellent."
"The most valuable feature is the clone copy."
"For us, the virtual warehousing is likely the most valuable aspect."
"I have found the solution's most valuable features to be storage, flexibility, ease of use, and security."
"Snowflake is an enormously useful platform. The Snowpipe feature is valuable because it allows us to load terabytes and petabytes of data into the data mart at a very low cost."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The number of standard adaptors could be extended further."
"Azure Data Factory's pricing in terms of utilization could be improved."
"Azure Data Factory could benefit from improvements in its monitoring capabilities to provide a more robust feature set. Enhancing the ease of deployment to higher environments within Azure DevOps would be beneficial, as the current process often requires extensive scripting and pipeline development. It is also known for the flexibility of the data flow feature, particularly in supporting more dynamic data-driven architectures. These enhancements would contribute to a more seamless and efficient workflow within GitLab."
"Areas for improvement in Azure Data Factory include connectivity and integration. When you use integration runtime, whenever there's a failure, the backup process in Azure Data Factory takes time, so this is another area for improvement."
"It can improve from the perspective of active logging. It can provide active logging information."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"Some known bugs and issues with Azure Data Factory could be rectified."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"Snowflake could improve migration. It should be made easier. It would be beneficial if it could offer some OLTP features. One of our customers was using Oracle for both data warehousing and OLTP workloads, and they were able to migrate their data warehousing workloads to Snowflake without major issues. However, for some of their OLTP requirements, such as needing a response time of fewer than 10 milliseconds for certain queries, Snowflake is currently unable to provide that."
"We would like to see more security including more masking and more encryption at the database level."
"If you go with one cloud provider, you can't switch."
"These aren't as crucial, but there are common errors sometimes where the database is down, or a table is nullified and a new table is added and you are not given access to that. With those errors, you don't have permissions."
"They have a new console, but I couldn't figure out anything in the new console. So, if I shift to the old console, I can figure out where to create the database schema and other things, but I have no idea where to go in the new console. That's one thing they can improve. I don't know why they created a new console to confuse. The old, classic console is much better."
"Maybe there could be some more connectors to other systems, but this is what they are constantly developing anyway."
"The solution could use a little bit more UI."
"I am still in the learning stage. It has good security, but it can always be more secure."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Snowflake is ranked 1st in Cloud Data Warehouse with 92 reviews. Azure Data Factory is rated 8.0, while Snowflake is rated 8.4. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". On the other hand, the top reviewer of Snowflake writes "Good usability, good data sharing and elastic compute features, and requires less DBA involvement". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Microsoft Azure Synapse Analytics and IBM InfoSphere DataStage, whereas Snowflake is most compared with BigQuery, Teradata, Vertica, AWS Lake Formation and Amazon EMR. See our Azure Data Factory vs. Snowflake report.
See our list of best Cloud Data Warehouse vendors.
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.