FSCK REPAIR TABLE (Databricks SQL)

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_name [DRY RUN]

Parameters

• table_name

  Identifies an existing Delta table. The name must not include a temporal specification.

• DRY RUN

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