topic Re: Find notebook executing user in Data Engineering

Find notebook executing user

g3kuser — Wed, 09 Apr 2025 06:59:38 GMT

I am trying to find notebook executing user using mssparkutils.env.getUserName() method.

This works fine when executing user is named user but fails when the user is SPN as the notebook owner is SPN.

Does this method not return user details if it is SPN?

Thanks,

Gayatri

Re: Find notebook executing user

Anonymous — Wed, 09 Apr 2025 12:09:01 GMT

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.

Re: Find notebook executing user

nilendraFabric — Wed, 09 Apr 2025 12:49:39 GMT

Hi @g3kuser

mssparkutils.env.getUserId() might works more reliably and can return the ID even when the notebook is executed by a service principal

Re: Find notebook executing user

g3kuser — Wed, 09 Apr 2025 23:04:44 GMT

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

Re: Find notebook executing user

Anonymous — Fri, 11 Apr 2025 09:58:23 GMT

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 MI

Re: Find notebook executing user

Anonymous — Mon, 14 Apr 2025 09:33:08 GMT

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.

Re: Find notebook executing user

g3kuser — Mon, 14 Apr 2025 11:02:23 GMT

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