config file to read from before processing

Question

Hello,
At present my configuration is being read from on-prem sql server table...
Which file format is best to have instead of the on-prem sql table?
For example, I can have .csv or excel, json, etc and read through the rows of the file but would like to kow which one is best to use and place in cloud blobstorage?
Thank you

Answer 1

Hey,
Every file type has its own advantages and disadvantages.
The file type selection should depend on how comfortable the team is parsing those files in case of any changes or modifications etc .
And also since you are planning to move from table to file for Config details, be sure that there are some limitations in lookup activity w.r.t the amount of records that can be retrived.