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

Parameters

  • 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.