How to get owner details of pipeline in Azure Data Factory?

Madhu Garikipati 5 Reputation points
2023-02-06T02:16:18.84+00:00

Is there a way to check who created the pipeline in ADF (considering Git is not configured)?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Nandan Hegde 36,146 Reputation points MVP Volunteer Moderator
    2023-02-06T04:30:30.7433333+00:00

    Hey,

    There is no out of the box feature to get those details.

    You would have to use logs to determine it.

    Whenever you create any new pipeline, a log is created in Activity log

    User's image

    User's image

    In case historical, you would need log enabled and need to manage the historical data

    0 comments No comments

  2. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-02-09T08:26:05.7033333+00:00

    Hi Madhu G,

    Welcome to Microsoft Q&A forum and thanks for posting your query.

    In addition to Nandan Hegde's inputs, if you have created a diagnostic setting to send the activity logs to Log Analytics workspace (Azure Monitor Logs), then you can use ADX Kusto query to get the details of the user/caller who created the pipeline. (Please note that for logs stored in Azure Monitor logs, there is a retention period of up to two years and the default retention period in Log Analytics is 90 days)

    Here is a sample query which you can use and modify as per your need:

    AzureActivity //TableName where you can find the logs
    | where OperationNameValue == "Microsoft.DataFactory/factories/pipelines/write" //OperantionNameValue
    | where Resource == "pl_parent_ValidateFilesInADLSToInvokeAdfPipeline"  //provide pipeline name 
    | project Caller, Resource ,OperationNameValue, OperationName, OperationId, TimeGenerated, Type
    | order by TimeGenerated asc 
    

    Here is the output looks like:

    User's image

    Hope this info helps.


    Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

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.