I need to fetch all active and inactive tasks in snowflake

I tried using task_history function..

CodePudding user response：

I would use the task_versions view in account_usage:

https://docs.snowflake.com/en/sql-reference/account-usage/task_versions.html

This view is currently Public Preview, but should have what you are looking for.

CodePudding user response：

Using SHOW TASKS command:

SHOW TASKS IN ACCOUNT;