Querying and viewing the task history

In this recipe, we will explore techniques that can be used to view the history of task execution, using the TASK_HISTORY table function.

Getting ready

The following steps describe the various ways to view and analyze the history of the execution of a single task as well as a series of tasks. Note that these steps can be run either in the Snowflake web UI or the SnowSQL command-line client.

To proceed with this recipe, ensure that you have already created and executed a few tasks; otherwise, no results will be returned.

How to do it…

To perform this recipe, let's try out the following steps:

1. We will use the task_history table function, which can be used to query the history of task execution. The function takes several parameters but all of them are optional, so to start with, we will run a query without any parameters. This will return the execution history of all the tasks:

   SELECT * FROM TABLE(information_schema...