upn

[smpa01]

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

[nilendraFabric]

Have you tried this

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

[smpa01]

sorry, I meant fabric notebook and not databricks notebook

[nilendraFabric]

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.

[smpa01 · Accepted solution]

mssparkutils.env.getUser

[nilendraFabric]

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