DROP BLOOM FILTER INDEX (Delta Lake on Databricks)

Drops a Bloom filter index.

Syntax

DROP BLOOMFILTER INDEX
ON [TABLE] table_identifier
[FOR COLUMNS(columnName1, columnName2, ...)]
  • 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.

The command fails if either the table name or one of the columns does not exist. All Bloom filter related metadata is removed from the specified columns.

When a table does not have any Bloom filters, the underlying index files are cleaned when the table is vacuumed.