Hi Team,
Can anyone suggest, how to load Pipeline details to Azure SQL?
For Example, I want to load a pipeline details to Master Table(Info. like Pipeline Name, Pipeline Activities, Data factory Name., so on) and Child Table (Info. like Pipeline Id, Activity Details with Transformation Level, Created date., so on).
I've tried with PowerShell
Get-AzDataFactoryV2Pipeline
but it gives Master level data, but I need to load these data into Azure SQL database, as well as i need to get a entry whenever a new pipeline created and also pipeline deleted we need to delete that entry from both master and child tables.
Please help me on this request.