bq_pseudo_sleep.sql

CREATE OR REPLACE PROCEDURE dbt_jyeo.fake_sleep(seconds INT64)
BEGIN
  DECLARE wait BOOL DEFAULT TRUE;
  DECLARE delay_time DATETIME DEFAULT DATETIME_ADD(CURRENT_DATETIME, INTERVAL seconds SECOND);
  WHILE wait DO
    IF (delay_time < CURRENT_DATETIME) THEN
      SET wait = FALSE;
    END IF;
  END WHILE;
  SELECT 'Slept for ' || seconds || ' seconds';
END;

call dbt_jyeo.fake_sleep(60);