Forum Discussion
Solved
Maintenance on Lakehouse Tables
Hi, I'm trying to run Maintenance on Lakehouse tables that are in OneLake. However, when I try and run Maintenance on the table with only the Optimize and V-Order flag selected I receive the fol...
Hi rtolsma ,
I believe the issue is that the Dataverse data is not actually managed by Fabric, tables are pointers to your dataverse environment, the error while annoying is correct.
That is very odd, when you click on the table and view source files, what does it show you?
I see several hundred 9-10MB files as per the screenshot below:
Can you right click at show the path of a single file?
Is there a delta_log folder in the directory?
Yes there is and it contains approximately 130+ .json files with some .checkpoint.parquet files in it.
Crazy idea,
Find the location of the Delta Table in OneLake and create a new table, from that path, then try to vacuum and optimize.