topic Re: User ID, Username and Notebook not populated in Lakehouse Delta table history in Data Engineering

User ID, Username and Notebook not populated in Lakehouse Delta table history

Naveen99K — Mon, 15 Apr 2024 14:22:14 GMT

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Expiscornovus — Mon, 15 Apr 2024 16:31:59 GMT

Just to double check. Do you mean the User ID and userName columns have NULL values when you run the describe history command:

https://learn.microsoft.com/en-us/azure/databricks/sql/language-manual/delta-describe-history

%%sql DESCRIBE HISTORY table_name

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Naveen99K — Tue, 16 Apr 2024 02:15:42 GMT

Expiscornovus , I am utilizing Pyspark code to import JSON data. Upon examining the table history, I noticed that the columns "User ID" and "userName" contain NULL values.

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Wed, 17 Apr 2024 17:28:46 GMT

Hi Naveen99K
Thanks for using Fabric Community.
Can you please elaborate more on the issue? Please provide some screenshots and explain so that I can help you better.

Thanks.

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Thu, 18 Apr 2024 16:59:50 GMT

Hi Naveen99K
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Naveen99K — Thu, 18 Apr 2024 17:13:02 GMT

User ID and userName columns have NULL values when you run the describe history command:

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Thu, 18 Apr 2024 17:53:14 GMT

Hi Naveen99K
Thanks for your feedback. Apologies for the issue you have been facing. I tried to repro the scenario and faced the same issue at my side. Hence this is a bug. I have reported the same to our internal team. The team is working to fix the issue as soon as possible.
I will keep you posted regarding the updates.
Appreciate your patience.

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Fri, 19 Apr 2024 17:24:52 GMT

Hi Naveen99K
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Mon, 22 Apr 2024 17:37:32 GMT

Hi @Naveen99K
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the query. Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Naveen99K — Tue, 23 Apr 2024 06:32:07 GMT

Anonymous , I'm currently awaiting a resolution from your internal team to address the bug.

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

Anonymous — Tue, 23 Apr 2024 07:21:04 GMT

Hi Naveen99K
The team is working on the bug to fix it. I will let you know once it gets fixed.
Appreciate your patience.

Re: User ID, Username and Notebook not populated in Lakehouse Delta table history

JosueMolina — Fri, 31 May 2024 21:08:57 GMT

Was this resolved? It's May 31st and I just tried checking on this information and was surprised it was still showing Nulls for everything.

Pretty sure data was being stored there last year.