Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Reply
Anonymous
Not applicable

Error DeltaTableIsInfrequentlyCheckpointed when accessing lakehouse table

I have no idea how it got into this state. Any help with fixing this would be appreciated.

 

I'm getting this error when i try and view a table in a datalake or manually run a vacuum

 

 

Delta table 'zsd_ship' has atleast '100' transaction logs, since last checkpoint. For performance reasons, it is recommended to regularly checkpoint the delta table more frequently than every '100' transactions. As a workaround, please use SQL or Spark to retrieve table schema.

 

 

The "_last_checkpoint" file contents are:

 

{"version":10,"size":4}

 

 

However the last checkpoint is file is file "00000000000000000340.checkpoint.parquet"

 

Can i just change the version in the last checkpoint file?

22 REPLIES 22
Anonymous
Not applicable

Hi @audrianna21 ,

I haven't got any updates internally. Incase if there is any update I will share it over here.

Thank you

Anonymous
Not applicable

Hello @Anonymous ,

We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket.
In case if support ticket is created please provide the ticket number as it would help us to track for more information.
Thanks

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.