Refresh Materialized View

This refreshes a materialized view

• By default, the refresh runs on the medium engine, costing 10 credits per refresh. To boost performance, pass in a JSON body with {"performance": "large"}, which consumes 20 credits per refresh.
• If you prefer medium performance, you can omit the performance parameter.
• You must own the materialized view to refresh it.

• After triggering the refresh, you can check the status by passing the returned execution_id into the Get Execution Status endpoint.
• To find the name of a materialized view:

Headers

X-Dune-Api-Key

string

required

API Key for the service

Path Parameters

name

string

required

Matview Name

Query Parameters

api_key

string

API Key, alternative to using the HTTP header X-Dune-Api-Key

Body

*/*

performance

string

Performance level of the refresh Available options: medium, large, defaults to medium

Response

200 - application/json

execution_id

string

Unique identifier for the execution triggered to refresh the materialized view

sql_id

string

Unique identifier for the materialized view