Forum Discussion

Yazdan's avatar
Yazdan
Advocate II
6 months ago

How to programmatically access “Submitted by” (pipeline runner) at pipeline or notebook runtime

Hi Fabric team,   In the Fabric Monitor view, pipeline runs clearly show the “Submitted by” column (see bellow), which correctly reflects the user who manually triggered the pipeline (e.g. Yazdan A...
data engineering
Environment
User Data Functions
Yazdan's avatar
Yazdan
Advocate II
6 months ago

Hi Tayloramy,

Thanks for the reply,
How can we access the pipeline activity logs in the pipeline environment at runtime?
Do you have any sample code for this?
Thanks,

  • tayloramy's avatar
    tayloramy
    Super User
    6 months ago

    Hi Yazdan, 

     

    Once you enable Workspace Monitoring, you should be able to access the logs in the workspace monitoring eventhouse that is created. 

     

    I believe these logs include who executed the pipeline. 

     

    • Yazdan's avatar
      Yazdan
      Advocate II
      6 months ago

      Hi tayloramy 

      Thanks for the guidance. I’ve enabled workspace monitoring and can now query the ItemJobEventLogs table.

      However, in this table I can only see ExecutingPrincipalId, which is the GUID of the user who triggered the pipeline. I need to retrieve the actual user details (given name and family name).

      Is there another table in the monitoring Eventhouse or somewhere else that contains user metadata which can be joined to ItemJobEventLogs to resolve the user name? Or any recommended approach to map ExecutingPrincipalId to a readable user identity?

      Thanks