Adding Double Quotes to CSV Header in Azure Data Factory

Question

The headers in the CSV look something like this: Name, Date, ID

I need the headers to be encapsulated by double quotation marks, something like this: "Name", "Date", "ID"

Note: The data below the headers are correctly encapsulated by double quotation marks, only the headers are missing them.

Answer 1

You can use a data flow activity and under sink settings, choose Quote All text.

Sink dataset settings

Dataflow Sink Tab setting

After execution, my file looks like