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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Naveen99K
Frequent Visitor

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

 
10 REPLIES 10
Expiscornovus
Resolver III
Resolver III

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

 

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

MayFabricCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.