FSCK REPAIR TABLE (SQL Analytics)

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.