sequencerowidazure-data-factory

Add sequential custom column using copy activity in ADF

I have a CSV source and Azure SQL as a sink for a copy activity in the Azure data factory pipeline. I want to add a RowID column (not part of CSV) to the sink table with values as 1,2,3,4........ Is it possible to do this without the use of data flows? Thanks in advance

ADF Pipeline Adding Sequential Value in Copy Activity

(similar to the case in the above link but I need not reset the rowID)

Solution

  • just for now, only the Data Flow Surrogate key can help to create the new column (RowId) with sequential value . Copy active support add column, but can't set the sequential values like 1,2,3....

    We can't achieve that with copy actives, it's impossible for now. Some other ways are that you need building the code with notebook or function active.

    HTH.