---
title: "This fetches a materialized view given a name"
method: GET
path: "/v1/materialized-views/{name}"
---

# This fetches a materialized view given a name

`GET /v1/materialized-views/{name}`

This fetches a materialized view given a name

## Path parameters

- `name` string, required

## Query parameters

- `api_key` string

## Headers

- `X-Dune-Api-Key` string, required

## Response `200`

OK

- MatviewsMatviewsGetResponse
  - `id` string
  - `is_private` boolean
  - `last_execution_ids` string[]
  - `owner_team_id` integer
  - `owner_user_id` integer
  - `query_id` integer
  - `schedule` MatviewsMatviewSchedule
    - `cron_expression` string
    - `expires_at` string
    - `next_execution_time` string
    - `performance` string
  - `sql_id` string
  - `table_size_bytes` integer

## Other responses

- `400` — Bad Request
- `401` — Unauthorized
- `403` — Forbidden
- `404` — Not Found
- `500` — Internal Server Error

---

[API](https://skmtc.dev/dune/apis/duneapi.md) · [All operations](https://skmtc.dev/dune/apis/duneapi/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/dune/duneapi/revisions/f3a7a865f95b/schema)