Data metric functions¶

Snowflake provides built-in system data metric functions to measure data quality for tables and views:

• ACCEPTED_VALUES (system data metric function)

• APPROX_QUANTILE_25 (system data metric function)

• APPROX_QUANTILE_50 (system data metric function)

• APPROX_QUANTILE_99 (system data metric function)

• AVG (system data metric function)

• BLANK_COUNT (system data metric function)

• BLANK_PERCENT (system data metric function)

• CASE_FORMAT_VIOLATION_COUNT (system data metric function)

• CASE_FORMAT_VIOLATION_PERCENT (system data metric function)

• DATA_METRIC_SCHEDULED_TIME (system data metric function)

• DUPLICATE_COUNT (system data metric function)

• FRESHNESS (system data metric function)

• FUTURE_TIMESTAMP_COUNT (system data metric function)

• FUTURE_TIMESTAMP_PERCENT (system data metric function)

• INVALID_JSON_COUNT (system data metric function)

• INVALID_JSON_PERCENT (system data metric function)

• INVALID_NUMERIC_TYPE_CAST_COUNT (system data metric function)

• INVALID_NUMERIC_TYPE_CAST_PERCENT (system data metric function)

• MAX (system data metric function)

• MEDIAN (system data metric function)

• MIN (system data metric function)

• NEGATIVE_COUNT (system data metric function)

• NEGATIVE_PERCENT (system data metric function)

• NULL_COUNT (system data metric function)

• NULL_PERCENT (system data metric function)

• REFERENTIAL_INTEGRITY_COUNT (system data metric function)

• ROW_COUNT (system data metric function)

• SPECIAL_CHARACTER_COUNT (system data metric function)

• SPECIAL_CHARACTER_PERCENT (system data metric function)

• STDDEV (system data metric function)

• STRING_LENGTH_AVG (system data metric function)

• STRING_LENGTH_MAX (system data metric function)

• STRING_LENGTH_MIN (system data metric function)

• UNIQUE_COUNT (system data metric function)

• UNTRIMMED_STRING_COUNT (system data metric function)

• UNTRIMMED_STRING_PERCENT (system data metric function)

• VARIANCE (system data metric function)

• ZERO_COUNT (system data metric function)

• ZERO_PERCENT (system data metric function)

For details, see System data metric functions.