Share via

config file to read from before processing

arkiboys 9,691 Reputation points
2021-09-14T04:00:00+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,840 questions
0 comments
Accepted answer
  1. Nandan Hegde 32,416 Reputation points MVP
    2021-09-14T05:12:37.643+00:00

    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.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.