---
title: "Get optimization opportunities for a job's Spark run with code linkage"
method: GET
path: "/api/v1/databricks/jobs/{job_id}/spark-analysis/opportunities"
tags: ["DATABRICKS", "Databricks", "Databricks Jobs"]
---

# Get optimization opportunities for a job's Spark run with code linkage

`GET /api/v1/databricks/jobs/{job_id}/spark-analysis/opportunities`

Get optimization opportunities for a Spark job with linked source code.

## Path parameters

- `job_id` string, required

## Query parameters

- `cluster_id` string, nullable
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- SparkOpportunitiesResponse — Response for spark opportunities endpoint.
  - `opportunities` SparkOpportunity[]
    - `opportunity_id` string, required
    - `insight_type` string
    - `name` string
    - `description` string
    - `severity` string
    - `application_id` string
    - `cluster_id` string
    - `cost_savings_min` number
    - `cost_savings_max` number
    - `time_savings_min` number
    - `time_savings_max` number
    - `stage_ids` integer[]
    - `code_links` SparkOpportunityCodeLink[]
      - `source_path` string
      - `cell_number` integer
      - `confidence` number
      - `original_code` string
  - `summary` SparkOpportunitySummary — Aggregate summary of opportunities.
    - `total` integer
    - `by_severity` object
    - `by_type` object
    - `total_time_savings_min` number
    - `total_time_savings_max` number
    - `total_cost_savings_min` number
    - `total_cost_savings_max` number

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