Jun 5, 2026: Filter rows in data metric function associations¶

You can now add a FILTER clause when associating a data metric function (DMF) with a table or view. The FILTER clause lets you scope the metric evaluation to a specific subset of rows without modifying the DMF definition or adding a view. The predicate is stored as part of the association and applied automatically each time the DMF runs.

For example, to count null values only in active records:

ALTER TABLE customer_data
  ADD DATA METRIC FUNCTION SNOWFLAKE.CORE.NULL_COUNT
    ON (email)
    FILTER (status = 'ACTIVE');

For more information, see Apply data quality checks to a subset of rows.