azure data factory vs snowflake

arkiboys 9,706

Hello,
I would like to convince the boss for us to use data factory rather than snowflake.

Any suggestions for a good link/video?

Thank you

Lawrence080-MSFT 46 Reputation points Microsoft Employee

2020-12-10T04:58:12.533+00:00

Hi @arkiboys ,

Thanks for the ask and using the forum .

While there is no one source that does a comparative analysis between the two services, consider the following as a key differentiator:

Snowflake is more comparable to Microsoft's Azure Synapse (formerly known as Azure Data Warehouse) in the sense that both services primarily act to ingest, integrate, store, and analyze data.

However, Azure Data Factory (ADF) takes the above functionalities a step further by acting as the platform that orchestrates those capabilities with the added benefits of workflow automation and options for data movement. It leverages a host of our other Azure data services (for example Azure SQL, HDInsights, Synapse Analytics, Databricks, etc) to give you more flexibility with how and where you can store, transform, or visualize data.

It is a more customizable and robust data transformation solution for this reason.
Lawrence080-MSFT 46 Reputation points Microsoft Employee

2020-12-17T22:22:30.993+00:00

Hi @arkiboys ,

We have not heard back from you on this and just wanted to follow up.

If you have resolution, request you to share the same here so other community members can benefit from that :)

Thanks!

Your answer