Forum Discussion

PriyaJha's avatar
PriyaJha
Icon for Helper I rankHelper I
1 year ago
Solved

How to identify session user of a notebook

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.

  • 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.

2 Replies

  • spencer_sa's avatar
    spencer_sa
    Icon for Impactful Individual rankImpactful Individual

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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