https://community.databricks.com/t5/data-engineering/delta-update-insert-from-multiple-source-tables/m-p/156019#M54338 <P>[Sorry for a novice question.]</P><P>I have multiple tables periodically updated from external sources (including insert, update, or delete). I need to update a target table, which is an outer join from multiple source tables without rewriting it each time. I do not need to do it in real time, but only once a day.</P><P>What are Databricks' best practices, techniques, etc?</P><P>Will appreciate pointers to documentation, examples, and/or Academy lectures.</P><P>Regards,</P><P>Stas</P><P>&nbsp;</P><P>Regards</P><P>Stas</P> Sun, 03 May 2026 09:24:48 GMT staskh 2026-05-03T09:24:48Z https://community.databricks.com/t5/data-engineering/delta-update-insert-from-multiple-source-tables/m-p/156019#M54338 <P>[Sorry for a novice question.]</P><P>I have multiple tables periodically updated from external sources (including insert, update, or delete). I need to update a target table, which is an outer join from multiple source tables without rewriting it each time. I do not need to do it in real time, but only once a day.</P><P>What are Databricks' best practices, techniques, etc?</P><P>Will appreciate pointers to documentation, examples, and/or Academy lectures.</P><P>Regards,</P><P>Stas</P><P>&nbsp;</P><P>Regards</P><P>Stas</P> Sun, 03 May 2026 09:24:48 GMT https://community.databricks.com/t5/data-engineering/delta-update-insert-from-multiple-source-tables/m-p/156019#M54338 staskh 2026-05-03T09:24:48Z