---
title: "Get MV details, column schema, and stats"
method: GET
path: "/views/{name}"
tags: ["Materialized Views"]
---

# Get MV details, column schema, and stats

`GET /views/{name}`

## Path parameters

- `name` string, required

## Response `200`

Full MV details

- ViewDetailResponse
  - `data` object, 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
    - `columns` ViewColumn[]
      - `name` string, required
      - `type` 'string' | 'int64' | 'float64' | 'timestamp' | 'boolean', required
      - `encoding` 'dictionary' | 'delta-of-delta' | 'delta-varint' | 'gorilla' | 'bitpacked'
      - `derived_from` string[] — Internal state columns for computed aggregates (e.g., avg = sum/count)
    - `group_by` string[]
    - `aggregations` string[]
    - `stats` object
      - `rows` integer
      - `segments` integer
      - `segments_pending_merge` integer
      - `storage_bytes` integer
      - `compression_ratio` number
      - `lag_ms` integer
      - `ingest_rate` number
      - `oldest_event` string, date-time
      - `newest_event` string, date-time
    - `source_view` string, nullable — Parent MV name for cascading views

## 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)