---
title: "Get queries with large data reads"
method: GET
path: "/api/v1/databricks/queries/full-scans"
tags: ["DATABRICKS", "Databricks", "Databricks Queries"]
---

# Get queries with large data reads

`GET /api/v1/databricks/queries/full-scans`

Get queries with large data reads (potential full scans).

## Query parameters

- `start_date` string, date, required — Start date
- `end_date` string, date — End date
- `min_read_bytes` integer — Minimum bytes read (default 1GB)
- `workspace_id` string, nullable — Filter by workspace ID
- `limit` integer — Maximum number of queries
- `navigationSource` string, nullable

## Headers

- `x-tenant` string, required

## Response `200`

Successful Response

- FullScanQueriesResponse — Response for queries with full scans.
  - `queries` QueryRecord[], required
    - `statement_id` string, required
    - `statement_type` string, nullable
    - `execution_status` string, nullable
    - `start_time` string, date-time, nullable
    - `end_time` string, date-time, nullable
    - `total_duration_ms` integer, nullable
    - `read_bytes` integer, nullable
    - `spilled_local_bytes` integer, nullable
    - `workspace_id` string, nullable
    - `workspace_name` string, nullable
    - `warehouse_id` string, nullable
    - `user_name` string, nullable
    - `error_message` string, nullable
  - `min_read_bytes` integer, required
  - `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/103580dad816/schema)