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
If the above response helps, please "accept the answer" and "up-vote" the same! Thank you!