Hi ,
We have a spark job write data in delta table for last 90 date partition. We have enabled spark.databricks.delta.autoCompact.enabled and delta.autoOptimize.optimizeWrite. Job takes 50 mins to complete. In that logic takes 12 mins and optimizewrite takes 37 mins to complete. Is any way to reduce total job time as the output per partition is 64mb file
We are using DBT 12 .