Azure data factory - adding a title row above the header row in a CSV file created

Ofri 26

Hey,
I've created a copy activity between Azure SQL (source) and ADLS v2 (Text Delimiter sink).
I've mapped the headers correctly, and the file was created as intended.

Now, how can I create a "Title" row above the header row? I don't mind creating the Title row in the copy activity itself or after the file is created.

Thanks!

Accepted answer

MarkKromer-MSFT 5,216 Reputation points Microsoft Employee

2023-01-09T07:50:33.767+00:00

The way to achieve this is ADF is to use a Data Flow and then set the "Headers" property in the Sink Settings.
Please sign in to rate this answer.

3 people found this answer helpful.
Ofri 26 Reputation points

2023-01-09T23:35:38.817+00:00

Thank you for your answer.
I've tried that, but instead of adding a row above the header row, the header row was being overridden by the new headers list in the "Headers" property in the Sink settings.

AnnuKumari-MSFT 33,986 Reputation points Microsoft Employee

2023-01-10T09:05:27.927+00:00

Hi @Ofri , Kindly make sure the 'First row as header' option is checked in sink dataset. For more details, kindly watch out this video.

Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.

Ofri 26 Reputation points

2023-01-10T11:09:00.68+00:00

It worked! Thanks :)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure data factory - adding a title row above the header row in a CSV file created

0 additional answers

Your answer