Azure Data factory Copy Activity need reference of guid as foreign key from other table

AZ_Shashank Sharma 1 Reputation point
2021-08-16T14:58:24.507+00:00

Azure Data factory Copy Activity need reference of guid as foreign key from other table (which was populated in last copy activity in pipeline)

for detail we are copying data from Mongo(on prem) to Sql server
only Activity that supports it is 'Copy Activity'
we populated the data into first table (Say Table A) (guid being generated on sql server side)
however while populating next table (Say Table B) from mongo (we got issue)
that we have foreign key constraint with first table i.e Table A

we tried lot of documentations and blogs , kindly point us to right direction or how this can be done
or if we need to provide some stored procedure (can you help how)

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,702 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
    2021-08-18T07:34:52.327+00:00

    Hi @AZ_Shashank Sharma ,

    Could you please elaborate more on below ask?
    "how to do the mapping of Guid of table A as foreign key parameter to Table B"

    However, in second copy activity source tab you can utilize addition column feature and pass your GUID value as new column there.

    Please Note, Copy activity in Azure data factory is purely meant for Data movement. Data flows in ADF helps to perform data transformations and then load data in to target.