扩展了 MONITOR、OPERATE、MONITOR EXECUTION 和 OWNER 权限的任务视图功能¶
Attention
This behavior change is in the 2025_01 bundle.
For the current status of the bundle, refer to Bundle History.
启用此行为变更捆绑包可扩展具有这些权限的角色的能力，以查看任务信息。
- Before the change:
具有 MONITOR、OPERATE、MONITOR EXECUTION 和 OWNERSHIP 权限的角色无法获得某些任务信息。
- After the change:
具有 MONITOR、OPERATE、MONITOR EXECUTION 和 OWNERSHIP 权限时，可用的任务信息会扩展。
下表描述了启用此行为变更捆绑包后现在可用的任务信息。
MONITOR 和 OPERATE 权限¶
| Before the change | After the change | |
|---|---|---|
| SHOW TASKS | ✔ | ✔ |
| DESCRIBE TASK | ✔ | ✔ |
| INFORMATION_SCHEMA table functions | ||
| TASK_HISTORY | ❌ | ✔ |
| CURRENT_TASK_GRAPHS | ❌ | ✔ |
| COMPLETE_TASK_GRAPHS | ❌ | ✔ |
| QUERY_HISTORY , QUERY_HISTORY_BY_* | 对于 Serverless Task： ✔ All queries ✔ Stored-procedure child queries that ran with caller’s rights. ❌ Stored-procedure child queries that ran with owner’s rights. 对于用户管理的任务： ❌ Task privileges do not determine what a role can view in QUERY_HISTORY. | 对于 Serverless Task： ✔ All queries ✔ Stored-procedure child queries that ran with caller’s rights. ❌ Stored-procedure child queries that ran with owner’s rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner’s rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility. |
| Snowsight | ||
| Task details > Run History, and Transformation > Tasks > Task Runs | ❌ | ✔ |
| Task details > Graph, and Transformation > Tasks > Task Graphs | ✔ | ✔ |
MONITOR EXECUTION 权限¶
| Before the change | After the change | |
|---|---|---|
| SHOW TASKS | ✔ | ✔ |
| DESCRIBE TASK | ✔ | ✔ |
| INFORMATION_SCHEMA table functions | ||
| TASK_HISTORY | ✔ | ✔ |
| CURRENT_TASK_GRAPHS | ✔ | ✔ |
| COMPLETE_TASK_GRAPHS | ✔ | ✔ |
| QUERY_HISTORY , QUERY_HISTORY_BY_* | ❌ Task privileges do not determine what a role can view in QUERY_HISTORY. | 对于 Serverless Task： ✔ All queries ✔ Stored-procedure child queries that ran with caller’s rights. ❌ Stored-procedure child queries that ran with owner’s rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner’s rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility. |
| Snowsight | ||
| Task details > Run History, and Transformation > Tasks > Task Runs | ✔ | ✔ |
| Task details > Graph, and Transformation > Tasks > Task Graphs | ✔ | ✔ |
OWNERSHIP 权限¶
| Before the change | After the change | |
|---|---|---|
| SHOW TASKS | ✔ | ✔ |
| DESCRIBE TASK | ✔ | ✔ |
| INFORMATION_SCHEMA table functions | ||
| TASK_HISTORY | ✔ | ✔ |
| CURRENT_TASK_GRAPHS | ✔ | ✔ |
| COMPLETE_TASK_GRAPHS | ✔ | ✔ |
| QUERY_HISTORY , QUERY_HISTORY_BY_* | 对于 Serverless Task： ✔ All queries ✔ Stored-procedure child queries that ran with caller’s rights. ❌ Stored-procedure child queries that ran with owner’s rights. 对于用户管理的任务： ❌ Task privileges do not determine what a role can view in QUERY_HISTORY. | 对于 Serverless Task： ✔ All queries ✔ Stored-procedure child queries that ran with caller’s rights. ❌ Stored-procedure child queries that ran with owner’s rights. 对于用户管理的任务： ✔ Task queries and stored-procedure child queries. ❌ Stored-procedure child queries that ran with owner’s rights require at least MONITOR privileges on the warehouse. Task privileges do not grant this visibility. |
| Snowsight | ||
| Task details > Run History, and Transformation > Tasks > Task Runs | ✔ | ✔ |
| Task details > Graph, and Transformation > Tasks > Task Graphs | ✔ | ✔ |
参考：1799