What privileges are required to create a task?

What privileges are required to create a task?
A . The global privilege create task is required to create a new task.
B . Tasks are created at the Application level and can only be created by the Account Admin role.
C . Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
D . The role must have access to the target schema and the create task privilege on the schema itself.

Answer: D

Explanation:

All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.

https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments