AndrewN
Databricks Employee
Databricks Employee

Have you tried using Liquid Clustering for your table instead of partition/z-ordering?https://docs.databricks.com/aws/en/delta/clustering