Materialized views store the results of a query as a table that can be queried like any other table, enabling you to build data pipelines within Dune. To learn more about how materialized views work, see the Materialized Views page.
Creating and refreshing materialized views requires an active trial or a paid plan and consumes credits. Materialized views count toward your plan’s storage quota. Free access is view-only. See plan limits.
Naming Convention
Materialized view names must follow these rules:- The full name qualifier is
dune.<your_team>.<name> - The name (last part) must be prefixed with
result_ - Example:
dune.myteam.result_daily_volume
Endpoints
Below is an overview of each endpoint for managing materialized views.Refresh and Performance Tiers
Each refresh of a materialized view triggers a query execution and consumes credits based on the performance level:- Medium: Extended timeout, 1x compute, priority queue. Best for most queries.
- Large: Extended timeout, 2x compute, priority queue. For complex queries with joins across large tables.