Can we find out the activities where a particular data set is used?

Suba Balaji 11,186 Reputation points
2022-08-27T08:01:17.417+00:00

Hi All,

Is there way I can figure out the activities where a particular data set is used? Same way we have the references to linked service under related column?

Wanted to delete the data sets which are not used by any activity. So, wondering is there an easy way to find it out.

TIA.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,322 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,447 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 29,886 Reputation points MVP
    2022-08-27T10:38:38.37+00:00

    Hey,
    Based on my understanding unfortunately there is no direct way as seen for linked services.

    you would have to extract the ARM template and search for that dataset as references :
    235445-image.png

    This can be done manually or you can write a powershell or some coding to parse through the ARM template for that dataset names and verify the dependencies if need be.

    0 comments No comments

0 additional answers

Sort by: Most helpful