topic Re: Since databricks runtime 12.1 &quot;WHEN NOT MATCHED BY SOURCE&quot; was added to MERGE syntax. For example, using that option, we can quickly delete ... in Data Engineering https://community.databricks.com/t5/data-engineering/since-databricks-runtime-12-1-quot-when-not-matched-by-source/m-p/10756#M5855 <P>Thank you for sharing @Hubert Dudek​&nbsp;</P> Fri, 24 Feb 2023 23:21:00 GMT jose_gonzalez 2023-02-24T23:21:00Z Since databricks runtime 12.1 "WHEN NOT MATCHED BY SOURCE" was added to MERGE syntax. For example, using that option, we can quickly delete ... https://community.databricks.com/t5/data-engineering/since-databricks-runtime-12-1-quot-when-not-matched-by-source/m-p/10755#M5854 <P>Since databricks runtime 12.1 "WHEN NOT MATCHED BY SOURCE" was added to MERGE syntax. For example, using that option, we can quickly delete all target rows which doesn't match any source.<span class="lia-inline-image-display-wrapper" image-alt="Screenshot 2023-01-24 130504"><img src="https://community.databricks.com/t5/image/serverpage/image-id/808i8E2558523196A1C9/image-size/large?v=v2&amp;px=999" role="button" title="Screenshot 2023-01-24 130504" alt="Screenshot 2023-01-24 130504" /></span></P> Tue, 24 Jan 2023 18:59:39 GMT https://community.databricks.com/t5/data-engineering/since-databricks-runtime-12-1-quot-when-not-matched-by-source/m-p/10755#M5854 Hubert-Dudek 2023-01-24T18:59:39Z Re: Since databricks runtime 12.1 "WHEN NOT MATCHED BY SOURCE" was added to MERGE syntax. For example, using that option, we can quickly delete ... https://community.databricks.com/t5/data-engineering/since-databricks-runtime-12-1-quot-when-not-matched-by-source/m-p/10756#M5855 <P>Thank you for sharing @Hubert Dudek​&nbsp;</P> Fri, 24 Feb 2023 23:21:00 GMT https://community.databricks.com/t5/data-engineering/since-databricks-runtime-12-1-quot-when-not-matched-by-source/m-p/10756#M5855 jose_gonzalez 2023-02-24T23:21:00Z