How to get the current userName in a Fabric Notebook

[JDawsonGLP]

Hi - 

I want to use the Change Feed capability in Delta tables when using Lakehouse and Notebooks. The History feature works great, and you can enable the Change Feed on a table to track and report detailed changes. However with the default Spark Session behaviour the userID and userName are always NULL.

I want to figure out how to get the "current user" that's submitting to spark from the notebook. I have tried mssparkutils, and when you use "spark.sparkContext.sparkUser()" you always get "trusted-service-user". Spark UI also shows this, but when you go to the "All Runs" view, is clearly knows the user ID of the Submitter.

[JDawsonGLP]

OK - thanks for the reply, I was trying the mssparkutils.env methods and saw they weren't available yet. 

Appreciate your response, I'll keep an eye on the blog for updates. As long as it's on the roadmap soon it's fine.

[Anonymous]

Hi @JDawsonGLP 

Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

[Anonymous · Accepted solution]

Hi @JDawsonGLP 
Thanks for using Fabric Community.
Apologies for the issue you have been facing. Currently there is no workaround to get the name of the current user that's submitting to spark from the notebook. We will have to wait until mssparkutils environment utils is ready. This is planned and is on road map. ETA : Q4 2023

Appreciate your patience.
Hope this helps. Please let us know if you have any further questions. Glad to help.