How to add a column to a file in azure synapse analytics?

Question

I am still quite new to this but I was wondering how to add columns to a file?

In my pipeline, I initially receive my data from an API, I combine multiple files from the same API to form a large file. I have now received the task to add columns to this file because we are planning on having one set of columns and we require some additional columns to make this possible for other sources.

Right now I am using the default column names i.e. "Prop_0", "Prop_1" etc... Anyway to add columns easily?

Answer 1

• Click the +new in the additional columns in the source tab of copy activity.

• You can enter the name of the column and value of the column in the respective text boxes.
• Value of the column can be static value, expression, $$filepath, $$COLUMN:<source_column_name>.

Refer microsoft document for more details on additional column during copy.