Scenario Inside a notebook you wrap two statements in one transaction: BEGIN ; INSERT INTO finance . fact_revenue Δ SELECT * FROM staging . view1 ; DELETE FROM finance . dim_regions Δ WHERE region_code = 'ZZ' ; COMMIT ; During execution, the DELETE fails on a foreign-key constraint. You need every inserted row automatically rolled back without manual cleanup.