---
title: "List Materialized Query Statuses"
method: GET
path: "/data/projects/{projectId}/materialized-queries/status"
tags: ["Data -- Materialized Queries"]
---

# List Materialized Query Statuses

`GET /data/projects/{projectId}/materialized-queries/status`

## Request

- Base URL: `https://partner.peaka.studio/api/v1`
- URL: `https://partner.peaka.studio/api/v1/data/projects/{projectId}/materialized-queries/status`
- Auth: HTTP bearer

Returns refresh status and schedule information for all materialized queries in the project.

## Path parameters

- `projectId` string, required

## Response `200`

List of materialized query statuses

- MaterializedQueryStatusView[]
  - `queryId` string: ID of the query
  - `queryName` string: Name of the query
  - `scheduleSettings` MaterializedQuerySchedule, nullable: Schedule configuration of a materialized query. Provide EITHER an interval schedule (`type=interval` with `repeatDuration`) OR a cron schedule (`type=cron` with `cronExpression` and optional `timezone`). Use `type=none` for no schedule. The fields that do not apply to the chosen type are omitted.
    - `type` 'interval' | 'cron' | 'none': Type of schedule.
    - `cronExpression` string, nullable: UNIX cron expression (minute hour day-of-month month day-of-week), e.g. '0 0 * * *' for every day at midnight. Set only when the schedule type is 'cron'.
    - `repeatDuration` string, nullable: ISO-8601 duration between refreshes, e.g. 'PT6H' (every 6 hours), 'PT12H' (twice daily), 'P1D' (daily). Set only when the schedule type is 'interval'.
    - `timezone` string, nullable: IANA timezone used to evaluate the cron expression, e.g. 'UTC' or 'Europe/Istanbul'. Set only when the schedule type is 'cron'.
  - `nextExecutionStartTime` string, nullable: Next scheduled execution start time (ISO 8601). Null when the schedule type is 'none' or cannot be computed.
  - `status` string: Status of the most recent refresh
  - `lastExecutionStartTime` string, nullable: Start time of the last refresh (ISO 8601)
  - `lastUpdateTime` string, nullable: Time the status was last updated (ISO 8601)

---

[API](https://skmtc.dev/peaka/apis/peaka-gateway-api.md) · [All operations](https://skmtc.dev/peaka/apis/peaka-gateway-api/llms.txt) · [OpenAPI document](https://skmtc.dev/peaka/apis/peaka-gateway-api/revisions/e68b033a22d5?raw)