topic Re: How to get the current userName in a Fabric Notebook in Data Engineering

How to get the current userName in a Fabric Notebook

JDawsonGLP — Mon, 13 Nov 2023 20:56:39 GMT

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.

Re: How to get the current userName in a Fabric Notebook

Anonymous — Tue, 14 Nov 2023 05:50:12 GMT

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.

Re: How to get the current userName in a Fabric Notebook

JDawsonGLP — Tue, 14 Nov 2023 07:06:09 GMT

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.

Re: How to get the current userName in a Fabric Notebook

Anonymous — Tue, 14 Nov 2023 07:08:20 GMT

Hi @JDawsonGLP

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