Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Naveen99K
Frequent Visitor

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

 
11 REPLIES 11
Expiscornovus
Super User
Super User

Hi @Naveen99K,

 

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

 

userid_username_null.png

 



Happy to help out 🙂

I share #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

@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.

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.

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

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

Naveen99K_0-1713460363473.png

 

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.

@v-nikhilan-msft , I'm currently awaiting a resolution from your internal team to address the bug.

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

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

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

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!