Big Query stored procedure example

CREATE OR REPLACE PROCEDURE 'proj.dataset.sp_name' ()
BEGIN
  DECLARE min_value INT64;
  CREATE OR REPLACE TEMPORARY TABLE table_1 as
  (select 1 as A);
  
  -- INIT table build
  CREATE TABLE IF NOT EXISTS ds.table_target
  (id_1, STRING
  , date_1, DATE
  , int_1, INT64
  )
  PARTITION by date_1;
  
  -- MERGE current run reuslts into underlying table( insert new, update eisting for date matches, delete existing if no within date range
  
  MERGE INTO tb.table_target t
  using table_1 s
  on t.id=s.id
  AND t.date_1=s.date_1
  WHEN MATCHED THEN
    UPDATE SET t.id_1=s.id_1
  WHEN NOT MATCHED THEN
    INSERT ROW
  WHEN NOT MATCHED BY SOURCE AND t.date_1 between min_date_1 and max_date_1 THEN
    DELETE;
  END
  

https://www.sqlservertutorial.net/sql-server-basics/sql-server-merge/