Server Error. Message : The metadata for the Delta table 'table_name' with the version 'n' could not

Hi abhilash_o_p 

Thank you for contacting the Microsoft Fabric Community Forum.

The error “The metadata for the Delta table with the version '46' could not be found” occurs because the Delta log entry for version 46 is incomplete. Although the _delta_log folder contains the expected JSON and CRC files, the JSON file only includes a commitInfo section and lacks the necessary add or remove actions that record data changes. This typically results from transactions that commit without modifying any data, such as schema-only changes or no-op writes. While Delta Lake supports these commits, certain engines like Microsoft Fabric when using ADLS Gen2 shortcuts require each version to represent a valid table state.

Since Fabric shortcuts read the Delta log directly, they cannot interpret version 46 correctly, leading to the MissingMetadataForDeltaTableVersion error. Recreating the shortcut temporarily resolves the issue by refreshing the metadata, but the root cause remains.

To address this, consider performing a minor write operation (such as a dummy update or inserting and deleting a row) to generate a new version with the correct metadata.Alternatively, reading the table at an earlier version (e.g., version 45) using versionAsOf can serve as a temporary workaround. To prevent similar issues, ensure all Delta write operations include a meaningful change so that each log version accurately reflects the table’s state and can be properly read by tools like Fabric.

Regards,

Karpurapu D,

Microsoft Fabric Community Support Team.