How to enable Liquid Clustering on an existing Delta Live Table (DLT) and syntax for enabling it

[Sakthi0311]

Hi all,

I’m working with Delta Live Tables (DLT) and want to enable Liquid Clustering on an existing DLT table that was already created without it.

Could someone please clarify:

1. How can I enable Liquid Clustering on an existing DLT table (without recreating the table if possible)?

2. What’s the correct syntax to use for enabling Liquid Clustering — both for:

   • Automatic Liquid Clustering

   • Manual clustering with specific columns

     For example:

     • Should I use something like this inside the DLT notebook?

       CREATE OR REFRESH LIVE TABLE my_table TBLPROPERTIES ( delta.feature.liquidClustering = 'enabled', delta.liquidCluster.autoCluster = 'true') AS SELECT * FROM source_table;

       Or should it be enabled differently using ALTER TABLE?

       I’ve seen documentation about Liquid Clustering for regular Delta tables, but not much for DLT-managed tables.
       Would appreciate any working examples or syntax confirmation from someone who’s done this successfully.

       Thanks in advance!

[szymon_dybczak]

Hi @Sakthi0311 ,

For SQL language you can enable LC for materialized views and streaming tables. So the syntax looks following:

If you want to use automatic clustering then use CLUSTER BY AUTO.