Is ADF overkill for this?
i am working on an ADF pipeline that runs every 15 minutes copying a tiny snapshot from Azure SQL into Azure Postgres. Around 1.2K rows in the main table and 12K in a related detail table. Two copy activities into staging, then a stored function does the insert, update, delete merge in one transaction, with guards so an empty source never wipes live data. So far it seems to work.
What bugs me is the cost and overhead. Each copy bills 4 DIU and a one minute minimum even though the transfer takes seconds, plus another minute of managed VNet queue time per copy. Every 15 minutes that adds up and starts to feel like I am paying for far more than the job actually needs.
If you were building this today, would you go with Functions on a timer, a Container Apps job, Logic Apps Standard, or pg_cron with a foreign data wrapper? Genuinely open to hearing if there is a leaner approach I am missing.