Drop Bloom Filter Index (Delta Lake on Databricks)

ON [TABLE] table_name
[FOR COLUMNS(columnName1, columnName2, ...)]

Drop a Bloom filter index.

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.