Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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.
Connect with Databricks Users in Your Area
Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโt want to miss the chance to attend and share knowledge.
If there isnโt a group near you, start one and help create a community that brings people together.
