CODEWITHSUNDEEP
azure-data-factory
ZZZSharePoint
ZZZSharePoint

Reputation: 1341

Adding a dynamic column in copy activity of azure data factory

I am using Data flow in my Azure Data factory pipeline in order to copy data from one cosmos db collection to another cosmos db collection. I am using cosmos SQL Api as the source and sink datasets.

Problem is when copying the documents from one collection to other,I would like to add an additional column whose value will be same as one of the existing key in json. I am trying with Additional column thing in Source settings but i am not able to figure out how can I add an existing column value in there. anyone with any help on this_

Upvotes: 0

Views: 8395

Answers (1)

NiharikaMoola
NiharikaMoola

Reputation: 5074

In case of copy activity, you can assign the existing column value to new column under Additional column by specifying value as $$COLUMN and add the column name to be assigned.

enter image description here

If you are adding new column in data flow, you can achieve this using derived column

enter image description here

enter image description here

Upvotes: 1

Related Questions