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
deborshi_nag's avatar
deborshi_nag
Super User
6 months ago

Hello Yazdan 

 

As a workaround you can enable Workspace monitoring on the workspace and query the KQL database. 

 

In the workspace > Settings > Monitoring > turn on Log workspace activity (Fabric creates the monitoring Eventhouse + KQL DB).
In the KQL DB, run a query like

ItemJobEventLogs
| where ItemKind == "Pipeline"
| project Timestamp, WorkspaceName, ItemName, JobStatus,
          ExecutingPrincipalType, ExecutingPrincipalId, DurationMs
| order by Timestamp desc

 

Yazdan's avatar
Yazdan
Advocate II
6 months ago

Hi Deborshi,

Thanks for the reply. However, in the result of this query I can’t see the user who triggered the pipeline. I need that information to be available in the pipeline environment at runtime.

  • deborshi_nag's avatar
    deborshi_nag
    Super User
    6 months ago

    Hi Yazdan Unfortunately, you won't be able to capture the Submitted By of a pipeline at runtime.