Programmatically check materialized view refresh

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.

Upvoters
Status

Open

Board

Feature Requests

Tags

Dune API

Date

About 2 years ago

Author

wint3rmute

Subscribe to post

Get notified by email when there are changes.