Azure Data Factory adding header to csv files in Pipeline

Question

I am moving data in csv files from on prem file share to ADLS Gen 2 , I want to add header before data end up in ADLS as source .csv files doesn't have headers, I know what headers I want to add, I don't see any option in source and sink setting where I can add custom headers before data end up in ADLS container as .csv file. any pointer articles on this ??

Answer 1

In ADF, create a new Data Flow. Add your CSV source with a no header dataset. Then add your Sink with a dataset that writes to ADLS G2 folder as a text delimited file WITH headers. In the Sink Mapping, you can name your columns:

Answer 2

Hi,

Please note in your dataflow sink (dataset) you need to add the first row has header. See below

Answer 3

Can we use headers from a different file to map the column names?

Answer 4

Hi, My source is common data model with dataflow to sink the transformation, i want to store the csv file column as header and without delimiter format. in preview data, i can see the structure is header is column and row is data. how do we configure.