---
title: "Get All Warehouses"
method: GET
path: "/warehouse/"
tags: ["WAREHOUSE"]
---

# Get All Warehouses

`GET /warehouse/`

## Query parameters

- `limit` integer, nullable
- `period` integer
- `sortAttribute` string, nullable
- `sortOrder` string, nullable
- `tags` string[], nullable
- `warehouseName` string[], nullable
- `warehouseSize` string[], nullable
- `costFilter` number, nullable
- `costFilterMode` string, nullable
- `autoTuneFilter` string[], nullable
- `opportunityFilter` string[], nullable
- `snowflakeTags` string[], nullable
- `resizeMode` string[], nullable
- `resizeEligible` boolean, nullable
- `instance_ids` string[], nullable
- `search` string, nullable
- `start_date` string, date-time, nullable
- `end_date` string, date-time, nullable
- `navigationSource` string, nullable
- `page` integer — Page number
- `size` integer — Page size

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageWarehouseFetchAllPageResponse
  - `items` WarehouseFetchAllPageResponse[], required
    - `warehouse_rk` string, required
    - `instance_id` string, required
    - `warehouse_name` string, required
    - `warehouse_size` string, required
    - `total_cost` string, required
    - `execution_time_p90` string, nullable
    - `tags` string[], required
    - `auto_suspend` number, nullable
    - `median_total_elapsed_time` string, nullable
    - `median_queuing_time` string, nullable
    - `median_queuing_time_percentage` number, nullable
    - `total_active_time` string, nullable
    - `idle_time` string, nullable
    - `idle_percentage` string, nullable
    - `realized_savings` string, nullable
    - `estimated_annualized_savings` string, nullable
    - `is_auto_tune_enabled` string, nullable
    - `auto_resize_mode` string, nullable
    - `auto_resize_eligible` boolean, nullable
    - `opportunities` string[], nullable
    - `snowflake_tags` 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)