Hii Team , can we set max file size during performing z-order optimization bcz i am having issue to getting 30mb file size so it is creating issue during update the data, i have set below property but not working this property . any idea ?

targetfilesize_refine='5000000' #byte

  
          alter table delta.`{table_loc}` 
            SET TBLPROPERTIES (
                'delta.targetFileSize'='{self.targetfilesize_refine}',
                'delta.tuneFileSizesForRewrites'='{self.tunefilesizesforrewrites_refine}'
                )
             """)

try setting

spark.databricks.delta.optimize.maxFileSize

won’t effect also in z-order ?