What is the best way to run sql loaders in Azure?

I’m looking to load data into an Azure sql database, the data will be loaded once a month, and I’d expected it to take around 30min to load. I’m planning on using either a python or .Net app that’s going to execute sql statements to do this, but I’m not tied to either. My question is, what would be a good way to host/run this in Azure? I know I could use a function, host the app in an app service, or there’s some stuff like data bricks and data factory that can do similar stuff but my org wants more control/ability to manipulate the data so I’m kind of tied more towards one off integrations.

Read more here: Source link