https://community.databricks.com/t5/get-started-discussions/liquid-clustering-with-incremental-ingestion/m-p/79120#M7745 <P>We ingest data incrementally from a database into delta tables using a column updatedUtc. This column is a datetime and is updated when the row in the database table changes. What about using this non-mutable column in "cluster by"? Would it require executing OPTIMIZE more often?&nbsp;</P><P>&nbsp;</P> Wed, 17 Jul 2024 11:58:50 GMT lbdatauser 2024-07-17T11:58:50Z https://community.databricks.com/t5/get-started-discussions/liquid-clustering-with-incremental-ingestion/m-p/79120#M7745 <P>We ingest data incrementally from a database into delta tables using a column updatedUtc. This column is a datetime and is updated when the row in the database table changes. What about using this non-mutable column in "cluster by"? Would it require executing OPTIMIZE more often?&nbsp;</P><P>&nbsp;</P> Wed, 17 Jul 2024 11:58:50 GMT https://community.databricks.com/t5/get-started-discussions/liquid-clustering-with-incremental-ingestion/m-p/79120#M7745 lbdatauser 2024-07-17T11:58:50Z https://community.databricks.com/t5/get-started-discussions/liquid-clustering-with-incremental-ingestion/m-p/79126#M7746 <P>It recommended to run optimize query in scheduled manner&nbsp;</P><P><A href="https://docs.databricks.com/en/delta/clustering.html#how-to-trigger-clustering" target="_blank">https://docs.databricks.com/en/delta/clustering.html#how-to-trigger-clustering</A></P><P>&nbsp;</P> Wed, 17 Jul 2024 13:32:12 GMT https://community.databricks.com/t5/get-started-discussions/liquid-clustering-with-incremental-ingestion/m-p/79126#M7746 greyamber 2024-07-17T13:32:12Z