What causes Dynamic Table Refresh Error?

A base table referenced by the Dynamic Table was dropped or renamed. A masking or row access policy on a base table changed, causing the Dynamic Table definition to conflict with the policy. The Dynamic Table query contains a function or SQL construct not supported in incremental refresh mode, causing fallback to full refresh to fail due to volume. The warehouse assigned to the Dynamic Table is suspended or undersized. The Dynamic Table query references an external table, which is not supported

How do I fix Dynamic Table Refresh Error?

Check the refresh history: `SELECT * FROM TABLE(INFORMATION_SCHEMA.DYNAMIC_TABLE_REFRESH_HISTORY(NAME => ' . . ')) ORDER BY REFRESH_START_TIME DESC LIMIT 10`.. Inspect the error message in the refresh history for the specific cause.. If a base table was renamed, recreate the Dynamic Table with the updated table reference.. If masking policies on base tables changed, recreate the Dynamic Table — policy changes on upstream tables trigger reinitialization.. Ensure the Dynamic Table query uses only functions supported for incremental refresh — check Snowflake documentation for unsupported constructs.. Verify the target warehouse is running: `SHOW WAREHOUSES`.

High severitydata source

Power BI Refresh Error:
Dynamic Table Refresh Error

What does this error mean?

A Snowflake Dynamic Table failed to refresh. Dynamic Tables are kept up-to-date automatically, but refresh failures leave the table stale without surfacing as a visible job failure unless monitoring is configured.

Common causes

1A base table referenced by the Dynamic Table was dropped or renamed
2A masking or row access policy on a base table changed, causing the Dynamic Table definition to conflict with the policy
3The Dynamic Table query contains a function or SQL construct not supported in incremental refresh mode, causing fallback to full refresh to fail due to volume
4The warehouse assigned to the Dynamic Table is suspended or undersized
5The Dynamic Table query references an external table, which is not supported

How to fix it

1Check the refresh history: `SELECT * FROM TABLE(INFORMATION_SCHEMA.DYNAMIC_TABLE_REFRESH_HISTORY(NAME => '<db>.<schema>.<table>')) ORDER BY REFRESH_START_TIME DESC LIMIT 10`.
2Inspect the error message in the refresh history for the specific cause.
3If a base table was renamed, recreate the Dynamic Table with the updated table reference.
4If masking policies on base tables changed, recreate the Dynamic Table — policy changes on upstream tables trigger reinitialization.
5Ensure the Dynamic Table query uses only functions supported for incremental refresh — check Snowflake documentation for unsupported constructs.
6Verify the target warehouse is running: `SHOW WAREHOUSES`.

Frequently asked questions

How do I trigger a manual refresh of a Dynamic Table?

Dynamic Tables do not support manual refresh triggers. If a refresh is stuck or failed, you can recreate the Dynamic Table or ALTER the target lag to force a new scheduling cycle.