---
title: "Get All Query Groups"
method: GET
path: "/query/v2/groups"
tags: ["QUERIES_V2"]
---

# Get All Query Groups

`GET /query/v2/groups`

## Query parameters

- `start_date` string
- `end_date` string
- `sort_key` string, nullable
- `sort_order` string, nullable
- `page` integer — Page number
- `size` integer — Page size
- `navigationSource` string, nullable
- `tags` string[], nullable
- `warehouses` string[], nullable
- `users` string[], nullable
- `roles` string[], nullable
- `query_hash` string, nullable
- `query_type` string[], nullable
- `instance_ids` string[], nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- PageQueryGroupPageItem
  - `items` QueryGroupPageItem[], required
    - `query_hash` string, required
    - `trimmed_query` string, required
    - `full_query` string, nullable
    - `total_run` integer, required
    - `avg_exec_time` string, required
    - `avg_cost` number, required
    - `total_cost` number, required
    - `annualized_cost` number, required
    - `distinct_warehouses` integer, required
    - `distinct_users` integer, required
    - `distinct_roles` integer, nullable
    - `tags` string[], required
    - `users` string[], required
    - `warehouses` string[], required
    - `roles` string[], nullable
    - `instance_id` integer, 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)