topic Is it possible to write tables to delta lake using upsert mode? Would it be more efficiant than overwrite? in Data Engineering https://community.databricks.com/t5/data-engineering/is-it-possible-to-write-tables-to-delta-lake-using-upsert-mode/m-p/23392#M16137 Thu, 07 Apr 2022 12:09:31 GMT Direo 2022-04-07T12:09:31Z Is it possible to write tables to delta lake using upsert mode? Would it be more efficiant than overwrite? https://community.databricks.com/t5/data-engineering/is-it-possible-to-write-tables-to-delta-lake-using-upsert-mode/m-p/23392#M16137 Thu, 07 Apr 2022 12:09:31 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-write-tables-to-delta-lake-using-upsert-mode/m-p/23392#M16137 Direo 2022-04-07T12:09:31Z Re: Is it possible to write tables to delta lake using upsert mode? Would it be more efficiant than overwrite? https://community.databricks.com/t5/data-engineering/is-it-possible-to-write-tables-to-delta-lake-using-upsert-mode/m-p/23393#M16138 <P>@Direo Direo​&nbsp;, Yes, you use Merge syntax for that <A href="https://docs.delta.io/latest/delta-update.html" alt="https://docs.delta.io/latest/delta-update.html" target="_blank">https://docs.delta.io/latest/delta-update.html</A>.</P><P></P><P>And is more efficient than overwriting if you want to update only part of the data, but you need to think about the logic of what to update so overwriting is easier to manage.</P> Thu, 07 Apr 2022 12:16:25 GMT https://community.databricks.com/t5/data-engineering/is-it-possible-to-write-tables-to-delta-lake-using-upsert-mode/m-p/23393#M16138 Hubert-Dudek 2022-04-07T12:16:25Z