Forum Discussion
DELETE Managed DELTA Table
frithjof_v "What if you run" - it will probably show 0. But it is extremely annoying.
But that is not onlly issue. assuming there is a lag between sql end point and lakehouse, I do expect the the lakehouse table view to show a 0 row table. Bu that is not the case sadly. Also, I don't want to truncate the table as it holds the required schema and partitions. I just need it to delete all the rows.
I am currently not being able to verify that either by SQL end point (does not show 0) or visually by looking at the lakehouse explorer (does not show an empty table)
Did you try clicking all the refresh buttons in the Lakehouse view?
Goes without saying
I'd suggest you create a support ticket to highlight this issue.
Also look at the recommendations in the docs if there's anything to be gained from there: https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
Perhaps you could also create an Idea at Fabrics Idea to highlight the need for faster sync between the different user interfaces.