Forum Discussion
Find notebook executing user
Hi g3kuser,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to Handle mssparkutils.env.getUserName() with SPNs;
1.mssparkutils.env.getUserName() works for named users, but does not reliably return SPN names.
2.SPNs are service accounts, and not treated as interactive users, so this method may return null or empty.
3.Pass the user or SPN name as a parameter to the notebook when triggered via pipeline or API.
4.Use mssparkutils.env.getExecutionId() to trace the notebook run or log trigger identity externally.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
6 Replies
Hi g3kuser,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to Handle mssparkutils.env.getUserName() with SPNs;
1.mssparkutils.env.getUserName() works for named users, but does not reliably return SPN names.
2.SPNs are service accounts, and not treated as interactive users, so this method may return null or empty.
3.Pass the user or SPN name as a parameter to the notebook when triggered via pipeline or API.
4.Use mssparkutils.env.getExecutionId() to trace the notebook run or log trigger identity externally.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.Thank you. Yes I implemented the same with the additional check on userName against email regex. This is added only to make it future proof. If MS changes the definition of the method and ends up returning a actual SPN name instead of exception getting raised as of today email regex will help in differentiating.
Thanks,
Gayatri
Hi g3kuser
mssparkutils.env.getUserId() might works more reliably and can return the ID even when the notebook is executed by a service principalThanks. My reason to look at userName is to identify if the user is named user or SPN and based on that initialize credential class to call Fabric APIs from notebook. In case of named user it returns the entire email addres and I can easily put a regex to verify it. Should I assume it will always return None/empty/exception if the user is SPN/MI?
Thanks,
Gayatri
Hi g3kuser,
Thank you for reaching out in Microsoft Community Forum.
Thank you nilendraFabric for the helpful response.
mssparkutils.env.getUserName() will return a valid email address for named interactive users
Use a simple check like this to differentiate:
user_name = mssparkutils.env.getUserName()
if user_name and "@" in user_name:
# Named user
else:
# SPN or MIPlease continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Hi g3kuser,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.
