SQL Server Creating new identity in ADF

2nc8po8w 于 2023-11-16 发布在其他

关注(0)|答案(1)|浏览(102)

i am working on ADF , i am loading data from adls to sql server through a pipeline. I want to create a ID in my pipeline that can be used as an identity to show the data of that particular run in the database.

In each run, there should be unique id created, through which we can refer to all the data which is loaded to DB in that particular run

I don't know how to create that. Can we run anu sql statement to create the ID and use it later in pipeline parameters?

sql-server

来源：https://stackoverflow.com/questions/77415772/creating-new-identity-in-adf

1条答案

按热度按时间

bzzcjhmw1#

To create identity for every new iteration of pipeline you can use two ways as follows.

**Pipeline run Id:**Each pipeline run has a unique pipeline run ID. You can use it as unique id for each pipeline run and store it in sql table as below:

Output for it

Run SQL statement to create the ID and then store it in Azure sql. You can use Lookup activity to run SQL statement on database and create an Id.

Store the output of SQL statement as unique id.

Mapping is same as above.

Output for this:

赞(0）回复(0）举报 2023-11-16

我来回答

SQL Server Creating new identity in ADF

1条答案

相关问题

热门标签

最新问答