---
title: "Trigger an async materialized view refresh"
method: POST
path: "/v1/materialized_view/{id}/refresh"
tags: ["MaterializedView", "Data"]
---

# Trigger an async materialized view refresh

`POST /v1/materialized_view/{id}/refresh`

Trigger an asynchronous refresh job for materialized view `id`.
Returns a job ID for tracking.

## Path parameters

- `id` string, required

## Query parameters

- `delimiter` string

## Request body

- RefreshMaterializedViewRequest
  - `identity` Identity — Identity information of a request.
    - `api_key` string — API key for authentication. REST NAMESPACE ONLY This is passed via the `x-api-key` header.
    - `auth_token` string — Bearer token for authentication. REST NAMESPACE ONLY This is passed via the `Authorization` header with the Bearer scheme (e.g., `Bearer <token>`).
  - `context` unknown
  - `id` string[] — Table identifier path (namespace + table name)
  - `src_version` integer, nullable — Optional source version to refresh from
  - `max_rows_per_fragment` integer, nullable — Optional maximum rows per fragment
  - `concurrency` integer, nullable — Optional concurrency override
  - `intra_applier_concurrency` integer, nullable — Optional intra-applier concurrency override
  - `source_task_size` integer, nullable — Optional number of source row ids per work item during expansion. Bounds per-actor memory for chunker materialized views.
  - `cluster` string, nullable — Optional cluster name (operational override)
  - `output_limit` integer, nullable — Post-trim cap on view row count after expansion. Valid only for chunker materialized views; returns 400 if set on other kinds.
  - `manifest` string, nullable — Optional inline JSON-serialized GenevaManifest. Operational override for this refresh only; does not mutate the view's snapshotted manifest. When omitted, the manifest stored in the view's metadata is used.

## Response `202`

Refresh job accepted

- RefreshMaterializedViewResponse
  - `context` unknown
  - `job_id` string, required — The job ID for tracking the refresh job

## Other responses

- `400` — Indicates a bad request error. It could be caused by an unexpected request body format or other forms of request validation failure, such as invalid json. Usually serves application/json content, although in some cases simple text/plain content might be returned by the server's middleware.
- `401` — Unauthorized. The request lacks valid authentication credentials for the operation.
- `403` — Forbidden. Authenticated user does not have the necessary permissions.
- `404` — A server-side problem that means can not find the specified resource.
- `503` — The service is not ready to handle the request. The client should wait and retry. The service may additionally send a Retry-After header to indicate when to retry.
- `5XX` — A server-side problem that might not be addressable from the client side. Used for server 5xx errors without more specific documentation in individual routes.

---

[API](https://skmtc.dev/lance-format/apis/lance-namespace-specification.md) · [All operations](https://skmtc.dev/lance-format/apis/lance-namespace-specification/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/lance-format/lance-namespace-specification/revisions/541331733d0c/schema)
