---
title: "Update mutable MV properties"
method: PATCH
path: "/views/{name}"
tags: ["Materialized Views"]
---

# Update mutable MV properties

`PATCH /views/{name}`

Only `retention` and `paused` can be changed without rebuild.
To change `q`, `partition_by`, or `group_by`, use `POST /views` with the same name (triggers rebuild).

## Path parameters

- `name` string, required

## Request body

- ViewPatchInput
  - `retention` string
  - `paused` boolean

## Response `200`

Updated

- ViewResponse
  - `data` ViewSummary, required
    - `name` string, required
    - `kind` 'projection' | 'aggregation', required
    - `query` string, required
    - `retention` string
    - `status` 'active' | 'backfilling' | 'rebuilding' | 'paused' | 'error', required
    - `version` integer
    - `rows` integer
    - `segments` integer
    - `storage_bytes` integer
    - `lag_ms` integer, nullable
    - `backfill` BackfillProgress
      - `total` integer
      - `processed` integer
      - `percent` number
      - `eta_seconds` integer
    - `previous_version` object
      - `version` integer
      - `status` string
    - `created_at` string, date-time
    - `last_event` string, date-time, nullable

## Other responses

- `404` — Resource not found

---

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