Recommended approach for scheduling a python script within Azure and pushing to database

Question

I have a python script that pulls data from an API, performs some transformations and finally spits out the data in a csv file.

Currently I use windows scheduler to perform this task daily.

I would like to further automate this task and have it sit within an azure environment that will run the script overnight on schedule but also push the results to an azure database.

I already have an azure subscription including a number of databases.

Two approaches I have read about are:

Virtual Machine within azure. Use the windows scheduler within the VM to run the script and push to database
Use azure web apps to run the script and push to database. (no VM needed)

I was hoping someone could recommend the more efficient approach to doing this?

Shirin · Accepted Answer · 2020-07-15 12:41:05Z

1

I would strongly recommend to look at Azure Functions.

It is basically serverless architecture. It will allow you to host your existing code without Virtual Machine or WebAPP.

It can be configured to run at your requirements and times.

https://azure.microsoft.com/en-us/services/functions/

You can set the connection string to your sql envrionment and connect to your sql database to push the data.

answered Jul 15, 2020 at 12:41

Shirin

1681 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Recommended approach for scheduling a python script within Azure and pushing to database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related