---
title: "Get expensive queries"
method: GET
path: "/api/v1/databricks/opportunities/expensive-queries"
tags: ["DATABRICKS", "Databricks", "Databricks Opportunities"]
---

# Get expensive queries

`GET /api/v1/databricks/opportunities/expensive-queries`

Get expensive queries that could be optimized.

## Query parameters

- `start_date` string, date, required — Start date
- `end_date` string, date — End date
- `min_duration_ms` integer — Minimum duration threshold (5 min default)
- `min_read_bytes` integer — Minimum bytes read threshold (5GB default)
- `workspace_id` string, nullable — Filter by workspace ID
- `limit` integer — Maximum results
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- ExpensiveQueriesResponse — Response for expensive queries opportunities.
  - `opportunities` ExpensiveQueryOpportunity[], required
    - `statement_id` string, required
    - `statement_type` string, nullable
    - `start_time` string, date-time, required
    - `total_duration_ms` integer, required
    - `read_bytes` integer, required
    - `spilled_local_bytes` integer, nullable
    - `workspace_id` string, nullable
    - `workspace_name` string, nullable
    - `user_name` string, nullable
    - `cost_score` number, required — Cost score for ranking
  - `total_count` integer, required

## Other responses

- `403` — Not authorized
- `404` — No ClickHouse database configured
- `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/50769cbf05d5/schema)