Build Azure Data Factory Framework
Budget: $30 – $250 AUD
I need an ADF framework to:
1) read a control table of metadata (this is a table of file names)
2) Read correponding file in blob container (based on pattern match). For example most files are exactly the same name as in control table.
2) execute stored proc passing in parameters read from each row in control table
3) mark in control table if successfully executed or failed
On successul processing of all above operations:
3) Loop back over control table to move each file to success folder
4) if any of steps 1-3 fail, all files need to be moved to failure folder
Please only respond if you are very experienced with Azure ADF.
Thanks
Andrew
1) read a control table of metadata (this is a table of file names)
2) Read correponding file in blob container (based on pattern match). For example most files are exactly the same name as in control table.
2) execute stored proc passing in parameters read from each row in control table
3) mark in control table if successfully executed or failed
On successul processing of all above operations:
3) Loop back over control table to move each file to success folder
4) if any of steps 1-3 fail, all files need to be moved to failure folder
Please only respond if you are very experienced with Azure ADF.
Thanks
Andrew