DUdune

This upserts (create or replace) a materialized view from an existing query

This upserts a materialized view from an existing query. If the materialized view with the given name

post/v1/materialized-views

Request

  • Base URL
    https://api.dune.com/api
  • URL
    https://api.dune.com/api/v1/materialized-views
  • Auth
    none declared. Required headers: X-Dune-Api-Key

Query parameters

api_keystring

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

Headers

X-Dune-Api-Keystring required

API Key for the service

Request body */*

cron_expressionstring
expires_atstring
is_privateboolean
namestring
performancestring

Performance tier for the refresh execution. Accepts small, medium, large. Omit to use the default tier for the source query's engine.

query_idinteger

Response

OK

execution_idstring

Unique identifier for the execution triggered to refresh the materialized view

namestring

Unique identifier for the materialized view

Example response

{
  "execution_id": "01HZ065JVE23C23FM2HKWQP2RT",
  "name": "dune.dune.result_erc_20_token_summary"
}

Changes

No recorded changes to this operation across all 2 revisions of this API.