FSCK REPAIR TABLE (Delta Lake on Databricks)

Removes the file entries from the transaction log of a Delta table that can no longer be found in the underlying file system. This can happen when these files have been manually deleted.

Syntax

FSCK REPAIR TABLE table_identifier [DRY RUN]
  • table_identifier

    • [database_name.] table_name: A table name, optionally qualified with a database name.
    • delta.`<path-to-table>` : The location of an existing Delta table.
  • DRY RUN

    Return a list of files to be removed from the transaction log.