mk1987c
New Contributor III

I think you can create partitioned and store it as delta table and optimize table using Zorder,

May i know your cluster configurations as well ?