CODEWITHSUNDEEP
azureazure-data-factoryazure-synapse
Mahix
Mahix

Reputation: 5

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

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

Image of pipeline

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?

Upvotes: 0

Views: 452

Answers (1)

Aswin
Aswin

Reputation: 7136

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

enter image description here

  • 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.

Upvotes: 0

Related Questions