---
title: "List expected partitions of a ducklake asset in a date range with their materialization status (enterprise)"
method: GET
path: "/w/{workspace}/assets/partitions_in_range"
tags: ["asset"]
---

# List expected partitions of a ducklake asset in a date range with their materialization status (enterprise)

`GET /w/{workspace}/assets/partitions_in_range`

## Path parameters

- `workspace` string, required

## Query parameters

- `path` string, required
- `from` string, date, required
- `to` string, date, required

## Response `200`

expected partitions in range with per-slice status — the missing/failed subset is the backfill worklist

- PartitionsInRange
  - `producer_path` string, required — the pipeline script that materializes the asset (managed `// materialize` target, or a partitioned writer using the SDK helpers) — the runnable a backfill launches
  - `partition_kind` 'daily' | 'hourly' | 'weekly' | 'monthly' | 'dynamic', required
  - `partitions` object[], required
    - `partition` string, required
    - `status` 'missing' | 'running' | 'materialized' | 'failed', required

---

[API](https://skmtc.net/windmill/apis/windmill-api.md) · [All operations](https://skmtc.net/windmill/apis/windmill-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/windmill/windmill-api/revisions/db0e7e036e34/schema)