topic Re: How to identify session user of a notebook in Data Engineering

How to identify session user of a notebook

PriyaJha — Fri, 06 Dec 2024 11:58:07 GMT

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.

Re: How to identify session user of a notebook

spencer_sa — Sat, 07 Dec 2024 16:24:32 GMT

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.

Re: How to identify session user of a notebook

Anonymous — Mon, 09 Dec 2024 01:12:40 GMT

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