Skip to main content
Version: 3.2

task_runs

task_runs provides information about the execution of asynchronous tasks.

The following fields are provided in task_runs:

FieldDescription
QUERY_IDID of the query.
TASK_NAMEName of the task.
CREATE_TIMETime when the task was created.
FINISH_TIMETime when the task finished.
STATEState of the task. Valid values: PENDING, RUNNING, FAILED, and SUCCESS. From v3.1.12, a new state MERGED is added especially for materialized view refresh tasks. When a new refresh task is submitted and the old task is still in the pending queue, these tasks will be merged and their priority level will be maintained.
DATABASEDatabase where the task belongs.
DEFINITIONSQL definition of the task.
EXPIRE_TIMETime when the task expires.
ERROR_CODEError code of the task.
ERROR_MESSAGEError message of the task.
PROGRESSThe progress of the task.
EXTRA_MESSAGEExtra message for the task, for example, the partition information in an asynchronous materialized view creation task.