Use Liquid Clustering

When enabled, Delta Lake liquid clustering replaces traditional table partitioning and ZORDER for simplified data layout and optimized query performance. When set to Y, generated CREATE TABLE statements include a CLUSTER BY clause instead of partition or ZORDER specifications, allowing Databricks to automatically manage data layout incrementally. Liquid clustering is a newer Databricks feature available from Databricks Runtime 13.3 and later — enable this setting only when your workspace and clusters meet that requirement. Use this setting when you want to simplify table maintenance and benefit from automatic data skipping without manually tuning partition keys.

Notes:

• This setting is part of the Databricks settings category.
• The default value for this setting is N.