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

# Get opportunities summary

`GET /api/v1/databricks/opportunities/summary`

Get summary counts of all opportunity types.

## Query parameters

- `start_date` string, date, required — Start date for query analysis
- `end_date` string, date — End date for query analysis
- `workspace_id` string, nullable — Filter by workspace ID
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- OpportunitiesSummaryResponse — Response for opportunities summary.
  - `summary` OpportunitiesSummary, required — Summary of all opportunity types.
    - `oversized_clusters` integer
    - `serverless_candidates` integer
    - `high_failure_jobs` integer
    - `expensive_queries` integer
    - `total_opportunities` integer

## 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/aab3fe5c9f05/schema)