topic upn in Data Engineering

upn

smpa01 — Sat, 15 Mar 2025 19:10:24 GMT

Can databricks notebook return the current UPN (equiavalent DAX USERPRINCIPALNAME())?

select current_user()

returns

trusted-service-user which is not useable.

I need it to return the following

john.doe@company.com

Re: upn

nilendraFabric — Sat, 15 Mar 2025 20:41:17 GMT

Have you tried this

user = dbutils.notebook.entry_point.getDbutils().notebook().getContext().userName().get()
print(user)

Re: upn

smpa01 — Sun, 16 Mar 2025 01:19:21 GMT

sorry, I meant fabric notebook and not databricks notebook

Re: upn

nilendraFabric — Sun, 16 Mar 2025 07:02:01 GMT

Fabric Notebooks execute under a service identity rather than the context of an individual user.

thats why When you run a statement such as `select current_user()`, the output is the service account (“trusted-service-user”) rather than the individual’s email address

This is a known limitation which has been discussed here in forum and enhancements to be made to the mssparkutils package.

Re: upn

smpa01 — Sun, 16 Mar 2025 13:17:29 GMT

mssparkutils.env.getUser

Re: upn

nilendraFabric — Sun, 16 Mar 2025 13:32:44 GMT

Thanks for sharing this. I haven't tried this 🙂