---
title: "Get Tasks Workloads"
method: GET
path: "/query/v2/tasks/list"
tags: ["QUERIES_V2"]
---

# Get Tasks Workloads

`GET /query/v2/tasks/list`

Get Snowflake tasks from snowflake_tasks_aggregated, grouped by qualified
task name plus warehouse and summed over the requested date range.

## Query parameters

- `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
- `warehouses` string[], nullable
- `databases` string[], nullable
- `schemas` string[], nullable
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageTaskWorkloadResponse
  - `items` TaskWorkloadResponse[], required
    - `database_name` string, required
    - `schema_name` string, required
    - `name` string, required
    - `warehouse_name` string, required
    - `run_count` integer, required
    - `success_count` integer, required
    - `failure_count` integer, required
    - `execution_time_ms` number, required
    - `queued_time_ms` number, required
    - `cost` number, required
    - `compute_cost` number, required
    - `serverless_cost` number, required
    - `credits_used` number, required
    - `serverless_credits_used` number, required
  - `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)