---
title: "Get Task Runs"
method: GET
path: "/query/v2/tasks/runs"
tags: ["QUERIES_V2"]
---

# Get Task Runs

`GET /query/v2/tasks/runs`

Individual runs of one Snowflake task (the drill-down opened when a task
name is clicked), read from snowflake_task_history and filtered to the
qualified (database_name, schema_name, name) triple. Summed metrics live on
/tasks/list; this returns one row per run with derived per-run durations.

The optional repeatable ``states`` query param narrows the per-run table to
the given run states (e.g. ``?states=FAILED&states=EXECUTING``); absent or
empty means "all states".

## Query parameters

- `database_name` string, required
- `schema_name` string, required
- `name` string, required
- `page` integer — Page number
- `size` integer — Page size
- `sortAttribute` string, nullable
- `sortOrder` string, nullable
- `start_date` string, date-time, nullable
- `end_date` string, date-time, nullable
- `states` string[], nullable
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageTaskRunResponse
  - `items` TaskRunResponse[], required
    - `run_id` integer, required
    - `attempt_number` integer, required
    - `name` string, required
    - `database_name` string, required
    - `schema_name` string, required
    - `task_database_id` integer, nullable
    - `task_schema_id` integer, nullable
    - `root_task_id` string, nullable
    - `graph_version` integer, nullable
    - `graph_run_group_id` string, nullable
    - `state` string, required
    - `scheduled_from` string, nullable
    - `scheduled_time` string, date-time, required
    - `query_start_time` string, date-time, nullable
    - `completed_time` string, date-time, nullable
    - `queued_time_ms` integer, nullable
    - `execution_time_ms` integer, nullable
    - `error_code` string, nullable
    - `error_message` string, nullable
    - `return_value` string, nullable
    - `query_id` string, required
    - `condition_text` string, nullable
    - `config` string, nullable
    - `backfill_info` string, nullable
  - `total` integer, nullable, required
  - `page` integer, nullable, required
  - `size` integer, nullable, required
  - `pages` integer, nullable

## Other responses

- `400` — Not supported for public user
- `403` — Not supported for public user
- `422` — Validation Error

---

[API](https://skmtc.net/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.net/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/myaltimate/fastapi/versions/aab3fe5c9f05/schema)