I just want to update the record on a conditional basis in azure blob storage file(records are just like SQL table), so my main questions are- which file format should i used for this scenario to read and update the record - one record should be updated at a time and how I can update the record back to the blob storage file

Hi Abhishek, You can refer this article : https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-portal

For file format, you can store images, documents, videos, audios and log files. I would recommend using file formats (xml or json) for updating you have to create custom scripts to read the file, update the file contenr and save it in blob.

Answers

Best way to read and update the azure blob storage file

Abhishek Chadha

574

I just want to update the record on a conditional basis in azure blob storage file(records are just like SQL table), so my main questions are-

which file format should i used for this scenario to read and update the record - one record should be updated at a time
and how I can update the record back to the blob storage file