topic What is the difference between the Auto Optimize set on Spark Session to the one set on Delta Table. in Data Engineering https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-the-auto-optimize-set-on-spark/m-p/39832#M27076 Mon, 14 Aug 2023 09:40:14 GMT Madhur 2023-08-14T09:40:14Z What is the difference between the Auto Optimize set on Spark Session to the one set on Delta Table. https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-the-auto-optimize-set-on-spark/m-p/39832#M27076 Mon, 14 Aug 2023 09:40:14 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-the-auto-optimize-set-on-spark/m-p/39832#M27076 Madhur 2023-08-14T09:40:14Z Re: What is the difference between the Auto Optimize set on Spark Session to the one set on Delta Ta https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-the-auto-optimize-set-on-spark/m-p/49930#M28655 <P>Hi&nbsp;<a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/86417">@Madhur</a>,</P> <P>The difference between Auto Optimize set on Spark Session and the one set on Delta Table lies in their scope and precedence.</P> <UL> <LI>Auto Optimize on Spark Session will apply to all Delta tables in the current session. It is a global configuration which takes precedence over the related table property during the current session.</LI> <LI>Auto Optimize on Delta Table, applies only to the specific Delta table on which it is set. If a property is set on a table, then this is the setting that is followed by default unless overridden by a SparkSession configuration.</LI> </UL> Thu, 26 Oct 2023 16:34:11 GMT https://community.databricks.com/t5/data-engineering/what-is-the-difference-between-the-auto-optimize-set-on-spark/m-p/49930#M28655 jose_gonzalez 2023-10-26T16:34:11Z