Checkpoint Parquet is not a Parquet file

Hi Guys, I have many tables on my lakehouse and just one table have a problem. This project have Delta Tables and all tables are running fine with Dremio, but sometimes one table return the following error:

IOException: /lakehouse/gold/dim_consultores/_delta_log/00000000000000000130.checkpoint.parquet is not a Parquet file. expected magic number [80, 65, 82, 49] at tail, but found [48, 49, 48, 48]

Can someone help me?

thank’s

You can Google that “expected magic number” error. In general, it usually means that the Parquet file has bad data.

@Ferrarini Is it possible the file was overwritten with the same file name but different file size? Can you try doing the below?

ALTER PDS <PDS_NAME> FORGET METADATA
ALTER PDS <PDS_NAME> REFRESH METADATA

Thanks
Bali