Snowflake · Schema

TaskRun

A task run executing a standalone task or a DAG of tasks starting from the root task.

DataData WarehouseData LakehouseCloud Data PlatformAnalyticsArtificial IntelligenceData EngineeringData GovernanceSQLApache IcebergModel Context ProtocolT1

Properties

Name Type Description
root_task_name string The name of the root task in the current task run.
database_name string The name of the current database for the task run.
schema_name string The name of the current schema for the task run.
state string The current state of the task run.
first_error_task_name string The name of the first task throwing an error in the task run.
first_error_code integer The first error code thrown in the task run.
first_error_message string The first error message thrown in the task run.
scheduled_time string The scheduled time for the task run.
query_start_time string The start time for the task run query.
next_scheduled_time string The next upcoming time for the task run.
completed_time string The time this task run was last completed.
root_task_id string The unique task ID for the root task.
graph_version integer The current version of the DAG on the task run.
run_id integer The unique ID for the current task run.
View JSON Schema on GitHub

JSON Schema

snowflake-taskrun-schema.json Raw ↑
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/TaskRun",
  "title": "TaskRun",
  "type": "object",
  "description": "A task run executing a standalone task or a DAG of tasks starting from the root task.",
  "properties": {
    "root_task_name": {
      "type": "string",
      "description": "The name of the root task in the current task run.",
      "readOnly": true,
      "example": "example_value"
    },
    "database_name": {
      "type": "string",
      "description": "The name of the current database for the task run.",
      "readOnly": true,
      "example": "example_value"
    },
    "schema_name": {
      "type": "string",
      "description": "The name of the current schema for the task run.",
      "readOnly": true,
      "example": "example_value"
    },
    "state": {
      "type": "string",
      "description": "The current state of the task run.",
      "enum": [
        "SCHEDULED",
        "EXECUTING",
        "SUCCEEDED",
        "FAILED",
        "CANCELLED",
        "SKIPPED"
      ],
      "readOnly": true,
      "example": "SCHEDULED"
    },
    "first_error_task_name": {
      "type": "string",
      "description": "The name of the first task throwing an error in the task run.",
      "readOnly": true,
      "example": "example_value"
    },
    "first_error_code": {
      "type": "integer",
      "description": "The first error code thrown in the task run.",
      "readOnly": true,
      "example": 10
    },
    "first_error_message": {
      "type": "string",
      "description": "The first error message thrown in the task run.",
      "readOnly": true,
      "example": "example_value"
    },
    "scheduled_time": {
      "type": "string",
      "description": "The scheduled time for the task run.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "query_start_time": {
      "type": "string",
      "description": "The start time for the task run query.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "next_scheduled_time": {
      "type": "string",
      "description": "The next upcoming time for the task run.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "completed_time": {
      "type": "string",
      "description": "The time this task run was last completed.",
      "format": "date-time",
      "readOnly": true,
      "example": "2026-01-15T10:30:00Z"
    },
    "root_task_id": {
      "type": "string",
      "description": "The unique task ID for the root task.",
      "readOnly": true,
      "example": "500123"
    },
    "graph_version": {
      "type": "integer",
      "description": "The current version of the DAG on the task run.",
      "readOnly": true,
      "example": 10
    },
    "run_id": {
      "type": "integer",
      "description": "The unique ID for the current task run.",
      "readOnly": true,
      "example": "500123"
    }
  },
  "example": {
    "root_task_name": "root_task",
    "database_name": "test_db",
    "schema_name": "test_schema",
    "state": "SCHEDULED",
    "first_error_task_name": "test_task",
    "first_error_code": 0,
    "first_error_message": "ERROR",
    "scheduled_time": "2024-06-18T01:01:01.111111",
    "query_start_time": "2024-06-18T01:01:01.111111",
    "next_scheduled_time": "2024-06-18T01:01:01.111111",
    "completed_time": "2024-06-18T01:01:01.111111",
    "root_task_id": "0",
    "graph_version": 0,
    "run_id": 0
  },
  "required": [
    "root_task_name",
    "database_name",
    "schema_name",
    "state",
    "scheduled_time",
    "next_scheduled_time",
    "root_task_id",
    "graph_version",
    "run_id"
  ]
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this
  • find_json_schemasBrowse and filter every JSON Schema in the catalog.
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/snowflake-taskrun"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

A second provider on the same verified email joins the account you already have.