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 Hubert-Dudek 2023-01-24T18:59:39Z 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 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