Hi There,
Currently we have the bronze, silver & gold delta tables partition by a string and yearmonth column, we maintain the entire historic data of 5 years and replace the partitions (latest 2 months) to add the new data.
We use overwrite mode to replace the effected partitions.
Can liquid clustering be applied on these tables? I want to take the advantage of liquid clustering but want to overwrite the effected months only.