Materialized tables are a way to store the results of a query in a table that can be queried like any other table. This is useful when you have a query that takes a long time to run, or when you want to use the results of a query in another query.
solana.transactions
or ethereum.traces
)SELECT count(*)
will not work)dune.<username>.result_<given_name>
.
If your username starts with a number, you’ll need to wrap the <username> in quotes i.e. dune."21co".result_stablecoin_total_supply_on_ethereum
When you query a materialized view in another query, it does not rerun the materialized view (unlike query views).
Matviews are marked separately in your query list and can also be filtered on.
name
in quotes i.e. dune."21co".result_stablecoin_total_supply_on_ethereum