How to identify session user of a notebook

[PriyaJha]

Hi,

I am trying to identify what user name does a notebook takes when it is been executed by an individual and via data pipeline.

I am executing following code in a notebook--

getpass.getuser()

The ouuput is -- trusted-service-user

When this notebook is called in a data pipeline, the output is same.

Please explain what is trusted-service-user and how to idenify execution user or session user of a notebook when triggered by an individual and when called in a pipeline.

[Anonymous]

Hi @PriyaJha ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

Regards,

Xiaoxin Sheng

[spencer_sa · Accepted solution]

Hi @PriyaJha 

getpass.getuser() is likely to return the internal user that the notebook is exeecuting as on the Spark node.
If you want to get the name of the logged in user (as controlled by Entra ID / Fabric), then you should use the following function to return the user running the job.

mssparkutils.env.getUserName()

This returns the user who is executing the notebook.

Be aware we have seen some unusual behaviour in the Monitoring hub when user A is executing a pipeline + notebook activity owned by user B.  In this case we have seen the pipeline executing under user A, but the notebook executing as user B.

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.