CODEWITHSUNDEEP
azureazure-data-factory
Abhijeet
Abhijeet

Reputation: 13896

Azure data factory price in real-world: Does Unchanged Upsert is treated as One Write for Billing?

Have you dealt with Azure data factory price in real-world for several million of records Driving te

If I configure Copy operation where Upsert mode was selected.. When there is no change in the row, would Microsoft treat it as one modified entity for Billing purposes?

Any pointers with real world experience on Data Factory Billing is much appreciated. Thanks for attempting to help out!

Upvotes: 0

Views: 272

Answers (1)

Nandan
Nandan

Reputation: 4945

Since ADF v2 is actually moving a data and comparing a value in case of upsert , a row operation is actually being performed and since copy activity is being executed, that means you are performing Orchestration operations which incurs cost. Hence it is charged even though there are no valid rows to upsert.

similar thread : https://learn.microsoft.com/en-us/answers/questions/1015698/cost-factors-for-azure-data-factory.html

Upvotes: 1

Related Questions