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()...
data pipeline
Notebook
  • spencer_sa's avatar
    spencer_sa
    1 year ago

    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.

spencer_sa's avatar
spencer_sa
Icon for Impactful Individual rankImpactful Individual
1 year ago

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.