snowflake_task_to_call_stored_procedure_to_unload_csv_to_s3_every_day_6_utc.sql

CREATE OR REPLACE TASK db_dev.revenue.fa_unload_task
  WAREHOUSE = LOAD_DEV  
  SCHEDULE  = 'USING CRON 0 18 * * * UTC'
WHEN
  SYSTEM$STREAM_HAS_DATA('OD_FORECAST_BOOKING_STREAM')
AS
  call db_dev.revenue.fa_unload_sp();
  
ALTER TASK IF EXISTS db_dev.revenue.fa_unload_task RESUME;