There is currently no way to programmatically determine the last refresh time of a materialized view, which is typically done through querying system tables.
For instance, the dashboard linked below aims to track MV loads, but it relies on contained data. On some days, no new data is generated, which does not necessarily mean that the MV has not been refreshed.
https://dune.com/wint3rmute/steakhouse-ens-health-monitoring
Having access to certain system tables would greatly enhance the reliability of such dashboards."
Please authenticate to join the conversation.
Open
Feature Requests
Dune API
About 2 years ago
wint3rmute
Get notified by email when there are changes.
Open
Feature Requests
Dune API
About 2 years ago
wint3rmute
Get notified by email when there are changes.