Pseudo-sleep function for BQ

bq_fake_sleep.sql

create or replace function dbt_jyeo.fake_sleep(seconds int64)
returns string
language python
options(runtime_version="python-3.11", entry_point="main")
as r'''
# python function takes time to spin up so this is a lower bound (wait at minimum).
import time
def main(seconds):
  time.sleep(seconds)
  return f'waited at least {seconds} seconds'
''';

select dbt_jyeo.fake_sleep(120);