ADF Copy to CSV - lack of headers

braxx 446 Reputation points
2020-12-31T15:08:01.847+00:00

Trying to copy a Parquet file from ADLS to Blob Storage with ADF Copy activity.
I need to have this transformed to CSV format. Copy works fine but for some reason an output CSV files do not contain column names (headers). There are no option in the sink tab of the activity to include headers. Is there a way to do so?
52662-capture12.png

52663-capture13.png

52671-capture14.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,208 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,811 Reputation points
    2020-12-31T15:30:48.157+00:00

    Hi @braxx ,

    To get the Header in your target CSV file, please check "First row as header" in the SINK csv Dataset (see the screenshots below), you will see the schema for the CSV Dataset in the Mapping tab instead of column1, column2... etc. Thanks!

    note: in the SINK csv Dataset, make sure you have schema updated with your desire column Headers

    52642-sinkcsvds.jpg

    If the above response helps, please "accept the answer" and "up-vote" the same! Thank you!

    4 people found this answer helpful.

0 additional answers

Sort by: Most helpful

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.