Has anyone built anything in data factory?
It seems to me that the pricing is suited to workload intensive activities and not to low volume activities just moving data around.
For example, I have 166 tables that I want to move from an applications database to staging tables in a data warehouse. Each table will have minimal changes. Some will change rarely (if ever), some will change maybe once a year, some monthly and a very select few will have changes daily (< 100 rows) of data. That being said, when I move them across they all need to stay synchronised so I need to check them all for changes each load. I would like to run the process once every 15 minutes.
Is this going to be 166 x $1 = $166 / month?