How to enable Liquid Clustering on an existing Delta Live Table (DLT) and syntax for enabling it
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2025 08:05 AM
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:
How can I enable Liquid Clustering on an existing DLT table (without recreating the table if possible)?
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2025 08:23 AM - edited 10-27-2025 08:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-27-2025 09:01 AM
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.