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.
Hi g3kuser
mssparkutils.env.getUserId() might works more reliably and can return the ID even when the notebook is executed by a service principal
Thanks. 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.