Would appreciate some help with scheduling a task to run a proc. I have successfully created the task using the code snippet below.
CREATE OR REPLACE TASK etl_monitoring_task_snowplow
WAREHOUSE = PSS_RAJA
SCHEDULE = '15 MINUTE'
WHEN
system$stream_has_data('OOBE.information_schema.load_history')
However, when attempting to execute the task with the following query:
ALTER TASK etl_monitoring_task_snowplow RESUME;
I encountered the following error message:
Cannot run task, EXECUTE TASK privilege needs to be granted to owner role