What causes Snowflake Data Metric Function Error?

DMF query references a column that was dropped or renamed in the monitored table. DMF execution role lacks SELECT privilege on the monitored table. DMF query timeout exceeded for a large table. DMF references an external function or UDF that is no longer available. Monitored table was dropped or moved to a different schema

How do I fix Snowflake Data Metric Function Error?

Check DMF execution history: `SELECT * FROM SNOWFLAKE.LOCAL.DATA_QUALITY_MONITORING_RESULTS WHERE METRIC_NAME = ' '`. Verify the DMF definition still matches the monitored table's current schema: `DESCRIBE FUNCTION (arg_types)`. Ensure the DMF execution role has SELECT on the monitored table. For timeout errors, optimise the DMF query or increase the statement timeout for the DMF role. If the monitored table changed, update the DMF to reference the correct columns

Medium severitydata quality

Power BI Refresh Error:
Snowflake Data Metric Function Error

What does this error mean?

A Snowflake Data Metric Function failed during its scheduled or on-demand execution. DMF errors prevent data quality scores from being updated and may block dependent governance policies.

Common causes

1DMF query references a column that was dropped or renamed in the monitored table
2DMF execution role lacks SELECT privilege on the monitored table
3DMF query timeout exceeded for a large table
4DMF references an external function or UDF that is no longer available
5Monitored table was dropped or moved to a different schema

How to fix it

1Check DMF execution history: `SELECT * FROM SNOWFLAKE.LOCAL.DATA_QUALITY_MONITORING_RESULTS WHERE METRIC_NAME = '<dmf>'`
2Verify the DMF definition still matches the monitored table's current schema: `DESCRIBE FUNCTION <dmf>(arg_types)`
3Ensure the DMF execution role has SELECT on the monitored table
4For timeout errors, optimise the DMF query or increase the statement timeout for the DMF role
5If the monitored table changed, update the DMF to reference the correct columns

Frequently asked questions

Where do I find Snowflake DMF execution results?

Query `SNOWFLAKE.LOCAL.DATA_QUALITY_MONITORING_RESULTS` in the same database as the monitored table, or `SNOWFLAKE.ACCOUNT_USAGE.DATA_QUALITY_MONITORING_RESULTS` for account-wide history.