Share via

Delete Data from tables dynamically using adf pipeline

R, Mohanraj [INMRKB] 1 Reputation point
2022-09-15T07:32:00.717+00:00

I have a requirement to delete data from tables based on table_name,column_name, retention days like last 7 days or 10 days. I have created a stored procedure which takes in these as parameters its working fine on database level.
I created a stored procedure activity in pipeline. Can you pls advice me on how to pass these parameters dynamically inside the pipeline at the trigger level.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,578 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bjoern Peters 8,871 Reputation points
    2022-09-15T07:56:28.027+00:00

    Hi,

    I am not 100% sure if this is what you are looking for, but I think so.

    https://stackoverflow.com/questions/69093957/send-parameters-in-trigger-adf

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.