Forum Discussion

joeguicearnold's avatar
joeguicearnold
Icon for Advocate I rankAdvocate I
2 years ago
Solved

Default dataset for Lakehouse not refreshing

The default dataset for my Lakehouse is not refreshing when the Lakehouse is being updated for one table.

 

This has happened a couple of times now and seems to be related to schema changes being made previously.  In this current case, the default dataset will not refresh unless the table is deleted and reloaded, any subsequent loads into the Lakehouse are shown there and in the SQL endpoint view but don't make it to the default dataset.  No schema changes have been made in this example since the last time the table was deleted and rebuilt, but I think the default dataset is corrupt in some way and won't refresh.  I can add measures from the SQL endpoint view and they show up in the default dataset but the table data is stale.

 

Lakehouse view:

 

SQL Endpoint view:

 

Dataset view:

 

3 Replies