Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Task does not execute in snowflake

I created a task on snowflake using CREATE TASK command. However, the task seems to be suspended, so I wanted to resume the task by following commend:

ALTER TASK TASK_DELETE3 RESUME;

I'm receiving following error message: Cannot execute task , EXECUTE TASK privilege must be granted to owner role

Does anyone know how to solve this issue?

like image 494
knozawa Avatar asked Sep 04 '26 19:09

knozawa


1 Answers

You need to run this command as ACCOUNTADMIN

GRANT EXECUTE TASK ON ACCOUNT TO ROLE <your_role>

like image 94
demircioglu Avatar answered Sep 07 '26 22:09

demircioglu



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!