CODEWITHSUNDEEP
azure-data-factory
Torben
Torben

Reputation: 101

How to map Data Flow parameters to Sink SQL Table

I need to store/map one or more data flow parameters to my Sink (Azure SQL Table).

I can fetch other data from a REST Api and is able to map these to my Sink columns (see below). I also need to generate some UUID's as key fields and add these to the same table.

I would like my EmployeeId column to contain my Data Flow Input parameter, e.g. named param_test. In addition to this I need to insert UUID's to other columns which are not part of my REST input fields.

How to I acccomplish that?

ADF Data Flow Mapping

Upvotes: 0

Views: 406

Answers (2)

Rakesh Govindula
Rakesh Govindula

Reputation: 11549

Adding to @Chen Hirsh, use the same derived column to get uuid values to the columns after REST API Source.

enter image description here

They will come into sink mapping:

enter image description here

Output:

enter image description here

Upvotes: 1

Chen Hirsh
Chen Hirsh

Reputation: 1400

You need to use a derived column transformation, and there edit the expression to include the parameters. derived column transformation expression builder

Upvotes: 1

Related Questions