---
title: "Get Stored Procedures Workloads"
method: GET
path: "/query/v2/workloads/stored-procedures/list"
tags: ["QUERIES_V2"]
---

# Get Stored Procedures Workloads

`GET /query/v2/workloads/stored-procedures/list`

Get stored procedures workloads

## Query parameters

- `page` integer — Page number
- `size` integer — Page size
- `sortAttribute` string, nullable
- `sortOrder` string, nullable
- `start_date` string, date-time
- `end_date` string, date-time
- `warehouses` string[], nullable
- `databases` string[], nullable
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageWorkloadPageResponse
  - `items` WorkloadPageResponse[], required
    - `hash` string, required
    - `query_summary` string, required
    - `job_count` integer, required
    - `cost` number, required
    - `query_type` string, required
    - `bytes_scanned` number, required
    - `execution_time` number, required
    - `warehouse_names` string[], required
    - `database_names` string[], 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

## Changes

- **2026-08-30** `82206441f16e` — 2 breaking
  - for the `query` request parameter `end_date`, default value was changed from `2026-08-27T15:28:29.590159` to `2026-08-27T15:28:29.614814`
  - for the `query` request parameter `start_date`, default value was changed from `2026-07-30T15:28:29.590131` to `2026-07-30T15:28:29.614784`
- **2026-08-29** `4e16bed5b3b0` — 2 breaking
  - for the `query` request parameter `end_date`, default value was changed from `2026-08-27T15:28:49.966704` to `2026-08-27T15:28:29.590159`
  - for the `query` request parameter `start_date`, default value was changed from `2026-07-30T15:28:49.966643` to `2026-07-30T15:28:29.590131`
- **2026-08-28** `1c5434b4b4fd` — 2 breaking
  - for the `query` request parameter `end_date`, default value was changed from `2026-08-27T15:28:47.366010` to `2026-08-27T15:28:49.966704`
  - for the `query` request parameter `start_date`, default value was changed from `2026-07-30T15:28:47.365964` to `2026-07-30T15:28:49.966643`
- **2026-08-27** `382a042b72c9` — 2 breaking
  - for the `query` request parameter `end_date`, default value was changed from `2026-08-25T13:00:45.911649` to `2026-08-27T15:28:47.366010`
  - for the `query` request parameter `start_date`, default value was changed from `2026-07-28T13:00:45.911616` to `2026-07-30T15:28:47.365964`
- …earlier changes not shown

[Full history](https://skmtc.dev/myaltimate/apis/fastapi/changes/query/v2/workloads/stored-procedures/list/get.md)

---

[API](https://skmtc.dev/myaltimate/apis/fastapi.md) · [All operations](https://skmtc.dev/myaltimate/apis/fastapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/myaltimate/fastapi/revisions/82206441f16e/schema)