SHOW TASKS and DESCRIBE TASKS commands: New column in output (Preview)¶
Attention
This behavior change is in the 2025_05 bundle.
For the current status of the bundle, refer to Bundle History.
When this behavior change bundle is enabled, the output of the SHOW TASKS and DESCRIBE TASK commands includes the following new column:
Column name |
Description |
|---|---|
|
Shows the user name of a user who runs a task by using EXECUTE AS USER. Shows as NULL if a task is run as the system user. |
Organizations that assign Snowflake security privileges by user can allow users to run team tasks by impersonating a user role or designated team role. A user or team grants this permission by using the GRANT IMPERSONATE AS USER command. Commands are run by users impersonating another user or team by using the CREATE TASKS … EXECUTE AS USER command.
For more information, see Run tasks with user privileges.
Ref: 2051