BigQueryでsleep関数

慣れればなんということもなさそうだけれど、一応メモ。

DECLARE DELAY_TIME DATETIME;
DECLARE WAIT BOOL;

BEGIN 
  SET WAIT = TRUE;
  SET DELAY_TIME = DATE_ADD(CURRENT_DATETIME, INTERVAL 10 SECOND);
  WHILE WAIT DO
    IF (DELAY_TIME < CURRENT_DATETIME) THEN
      SET WAIT = FALSE; 
    END IF; 
  END WHILE;
END

参考文献

• Is there a wait method for Google BigQuery SQL