Forum Discussion
rtolsma
Helper I
Helper IMaintenance 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.
richbenmintz
Resident Rockstar
Resident RockstarThat is very odd, when you click on the table and view source files, what does it show you?
rtolsmaHelper I
Helper II see several hundred 9-10MB files as per the screenshot below:
- richbenmintz
Can you right click at show the path of a single file?
Is there a delta_log folder in the directory?
- rtolsma
Yes there is and it contains approximately 130+ .json files with some .checkpoint.parquet files in it.
- richbenmintz
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.