I have a python script and some SQL which I would like to have setup to run automatically using Webjobs in MS Azure. If you want to use another approach please let me know in your reply. I would like the following:
1. Schedule starts the python script
2. Once completed pick up output and insert into MS SQL table
3. New SQL query to be developed which will clean one field in the table (parsing out specific values which I will provide)
4. Once complete automatically run a further number of SQL queries which have already been built.
There may be some modifications needed to the python concerning where to pick up the input csv from, currently it picks up from a shared location and the output file points to a shared location, these will need to be modified to point to the new location.
Please mention "red" in your reply.