SnowPro Advanced Data Engineer · Data Governance

A dynamic table SALES_DT is defined with TARGET_LAG = '5 minutes' but downstream reports have shown stale data for 40 minutes. The Data Engineer needs the state and error message for each recent refresh attempt to determine whether refreshes are failing or merely queued. Which query provides this per-attempt detail with the least reporting delay?

• ASHOW DYNAMIC TABLES LIKE 'SALES_DT';
• BSELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.DYNAMIC_TABLE_REFRESH_HISTORY WHERE NAME = 'SALES_DT' AND REFRESH_START_TIME > DATEADD('hour',-1,CURRENT_TIMESTAMP());
• CSELECT * FROM TABLE(INFORMATION_SCHEMA.DYNAMIC_TABLE_REFRESH_HISTORY(NAME=>'SALES_DT'));
• DSELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY(TASK_NAME=>'SALES_DT'));