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.
"The initial setup is very quick and easy."
"It has built-in connectors for more than 100 sources and onboarding data from many different sources to the cloud environment."
"The most valuable features are data transformations."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"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."
"It is easy to integrate."
"The solution is okay."
"It is a complete ETL Solution."
"Scaling is a big plus point of Snowflake."
"It is a very easy-to-use solution. It is user-friendly, and its setup time is very less."
"It is a very good platform. It can handle structured and semi-structured data, and it can be used for your data warehouse or data lake. It can load and deal with any data that you have. It can extract data from an on-premises database or a website and make it available in the cloud. It has very fast implementation and integration as compared to other solutions. There is no need for the DBA to manage or do the day-to-day DBA tasks, which is one of the greatest things about it."
"The most valuable feature is the snapshot database. In one second, you can just take a snapshot of the database for test purposes."
"The solution is very easy to use."
"Snowflake's most valuable features are data enrichment and flattening."
"The product's most important feature is unloading data to S3."
"I like the fact that we don't need a DBA. It automatically scales stuff."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"I would like to be informed about the changes ahead of time, so we are aware of what's coming."
"The Microsoft documentation is too complicated."
"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."
"We are too early into the entire cycle for us to really comment on what problems we face. We're mostly using it for transformations, like ETL tasks. I think we are comfortable with the facts or the facts setting. But for other parts, it is too early to comment on."
"They require more detailed error reporting, data normalization tools, easier connectivity to other services, more data services, and greater compatibility with other commonly used schemas."
"There is no built-in pipeline exit activity when encountering an error."
"Every product has room for improvement, although in this case, it needs some broadening of the functionality."
"If you go with one cloud provider, you can't switch."
"Snowflake can improve its machine learning and AI capabilities."
"The design of the product is easily misunderstood."
"Support needs improvement, as it can take several days before you get some initial support."
"Portability is a big hurdle right now for our clients. Porting all of your existing SQL ecosystem, such as stored procedures, to Snowflake is a major pain point. Currently, Snowflake stored procedures use JavaScript, but they should support SQL-based stored procedures. It would be a huge advantage if you can write your stored procedures using SQL. It seems that they are working on this feature, and they are yet to release it. I remember seeing some notes saying that they were going to do that in the future, but the sooner this feature comes out, it would be better for Snowflake because there are a lot of clients with whom I'm interacting, and their main hurdle is to take their existing Oracle or SQL Server stored procedures and move them into Snowflake. For this, you need to learn JavaScript and how it works, which is not easy and becomes a little tricky. If it supports SQL-based procedures, then you can just cut-paste the SQL code, run it, and easily fix small issues."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"The scheduling system can definitely be better because we had to use external airflow for that. There should be orchestration for the scheduling system. Snowflake currently does not support machine learning, so it is just storage. They also need some alternatives for SQL Query. There should also be support for Spark in different languages such as Python."
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.