Delta Live Tables are not actully tables, it is a pipeline tool that manage delta tables. you can enable liquid clustering on the delta tables that are used by DLT. am not sure about MV, but I think it should work since MVs are materialised as detla table too. but maybe you can try it and let us know the result.

Hi @amr, materialised views are not tables, they are views. Liquid clustering is not supported on views so it will throw [EXPECT_TABLE_NOT_VIEW.NO_ALTERNATIVE] error. 

Unfortunately it will be the same case for the "optimize" command as well. 

what is the Python syntax for adding liquid clustering to a Delta Live Table???

@Dlt.table(
name=table_name,
comment="just_testing",
table_properties={
"quality": "gold",
"mergeSchema": "true"
},
cluster_by=["test_id", "find_date"] # Optimizes for queries filtering on these columns
)
def testing_table():
return create_testing_table(df_final, test_type)