dynamic_table_refresh_history is a Snowflake built-in function for monitoring dynamic table executions. Its output records scheduled refresh attempts according to the table’s target lag, including attempts where no source data changed. section 5.4
Query refresh history
select * from table(information_schema.dynamic_table_refresh_history()) order by refresh_start_time desc; section 5.4
select * from table(information_schema.dynamic_table_refresh_history()) order by refresh_start_time desc;
Run the supplied SQL listing to inspect the newest dynamic table refresh attempts first. section 5.4
Use the returned records to:
- Confirm that refreshes occur at the configured target-lag frequency, such as once per minute. section 5.4
- Troubleshoot failed refreshes and investigate reported errors. section 5.4
