Forum Discussion
DELETE Managed DELTA Table
Hi, smpa01
After testing, after executing this T-SQL, the data in this table can be deleted normally, and then refresh, there is no data in the table in Lakehouse.Delete works fine in Notebook. Make sure you have permission to modify the table, retry deleting and refreshing.
Notebook:
Lakehouse:
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Anonymous I see this however.
" Make sure you have permission to modify the table, retry deleting and refreshing" - yes, I am the admin
Perhaps it's the sync between Lakehouse and SQL Analytics Endpoint which is taking a long time in your case.
What if you run
%%sql
SELECT Count(*) FROM tableName
in the Notebook in the next cell after you run the truncate or delete rows. Perhaps this will show that the table is indeed empty, even if the SQL Analytics Endpoint doesn't know that yet.
https://learn.microsoft.com/en-us/fabric/data-warehouse/sql-analytics-endpoint-performance
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)
