CODEWITHSUNDEEP
azure-sql-databaseazure-data-factory
Matzka
Matzka

Reputation: 135

How can I add a key attribute column before storing it into Azure SQL DB?

I am using Data Factory to shift data from a Data Lake Storage Gen2, transform the data and finally I want to store the data in an Azure SQL DB.

How can I add a column with an key attribute (bigint) based on the rowNumber()? I tried to use the functionality "Derived Column", but I can't choose the function rowNumber() as it is only valid for window transformations.

Thanks

Upvotes: 0

Views: 43

Answers (1)

Leon Yue
Leon Yue

Reputation: 16411

You could use Surrogate key transformation in mapping data flow.

Create the key based the row number of the data:

enter image description here

enter image description here

Upvotes: 1

Related Questions