topic Re: What is more optimized way of writing delta table in a workflow, &quot;append&quot; or &quot;ov in Data Engineering https://community.databricks.com/t5/data-engineering/what-is-more-optimized-way-of-writing-delta-table-in-a-workflow/m-p/82029#M36485 <P>There's no "optimized way", as these are two different concepts, and depend on your use case: Overwrite&nbsp; removes existing data, i.e. replaces it with new data, while append adds new data to your existing table.</P> Tue, 06 Aug 2024 11:53:04 GMT Witold 2024-08-06T11:53:04Z What is more optimized way of writing delta table in a workflow, "append" or "overwrite"? https://community.databricks.com/t5/data-engineering/what-is-more-optimized-way-of-writing-delta-table-in-a-workflow/m-p/82017#M36480 <P>What is more optimized way of writing delta table in a workflow which is running every hour, "append" or "overwrite"?</P> Tue, 06 Aug 2024 10:20:50 GMT https://community.databricks.com/t5/data-engineering/what-is-more-optimized-way-of-writing-delta-table-in-a-workflow/m-p/82017#M36480 hpant1 2024-08-06T10:20:50Z Re: What is more optimized way of writing delta table in a workflow, "append" or "ov https://community.databricks.com/t5/data-engineering/what-is-more-optimized-way-of-writing-delta-table-in-a-workflow/m-p/82029#M36485 <P>There's no "optimized way", as these are two different concepts, and depend on your use case: Overwrite&nbsp; removes existing data, i.e. replaces it with new data, while append adds new data to your existing table.</P> Tue, 06 Aug 2024 11:53:04 GMT https://community.databricks.com/t5/data-engineering/what-is-more-optimized-way-of-writing-delta-table-in-a-workflow/m-p/82029#M36485 Witold 2024-08-06T11:53:04Z