Use this workspace setting to configure whether new Delta tables are created with deletion vectors enabled by default.
This setting applies to all tables created using Databricks SQL warehouses (version 2023.50 and above) and clusters running Databricks Runtime 14.0 and above.
This setting does not apply to tables created with Delta Live Tables.
Databricks recommends using deletion vectors for all tables except for those used in workloads with incompatible Databricks Runtime versions or external Delta clients. See What are deletion vectors?.
Tables with deletion vectors enabled automatically leverage predictive I/O for updates in Photon-enabled clusters. See Use predictive I/O to accelerate updates.
To manage this setting:
Go to the admin settings page.
Click the Advanced tab.
Select your desired behavior from the dropdown next to Auto-Enable Deletion Vectors.
You can choose from the following options:
Disabled. Do not automatically enable deletion vectors.
New UC managed and Databricks SQL tables
Enable deletion vectors on all new Delta tables managed by Unity Catalog or created in Databricks SQL.
All new tables
Enable deletion vectors on all new Delta tables.
Do not automatically enable deletion vectors.
You must restart any running compute to apply changes to this setting.
Databricks has introduced the Auto-Enable Deletion Vectors setting as an opt-in.
During the introductory period, Databricks encourages admins to manually configure one of the explicit choices.
In the near future, the behavior associated with the Default option will change from Disabled to All new tables. To avoid having this change automatically applied to your workspaces, select an option other than Default.
Databricks recommends selecting Disabled if you read newly created tables using clients that don’t support deletion vectors. See Compatibility with Delta clients.