Data metric functions¶

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

• ACCEPTED_VALUES (system data metric function)
• ACCURACY (system data metric function)
• ALL_SPACE_COUNT (system data metric function)
• ALL_SPACE_PERCENT (system data metric function)
• APPROX_QUANTILE_20 (system data metric function)
• APPROX_QUANTILE_25 (system data metric function)
• APPROX_QUANTILE_40 (system data metric function)
• APPROX_QUANTILE_50 (system data metric function)
• APPROX_QUANTILE_60 (system data metric function)
• APPROX_QUANTILE_80 (system data metric function)
• APPROX_QUANTILE_95 (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)
• CONTAINS_SPACES_COUNT (system data metric function)
• CONTAINS_SPACES_PERCENT (system data metric function)
• DATA_METRIC_SCHEDULED_TIME (system data metric function)
• DUPLICATE_COUNT (system data metric function)
• DUPLICATE_PERCENT (system data metric function)
• EMPTY_STRING_COUNT (system data metric function)
• EMPTY_STRING_PERCENT (system data metric function)
• EXTREME_OUTLIER_COUNT (system data metric function)
• EXTREME_OUTLIER_IQR_COUNT (system data metric function)
• EXTREME_OUTLIER_IQR_PERCENT (system data metric function)
• EXTREME_OUTLIER_PERCENT (system data metric function)
• EXTREME_OUTLIER_ZSCORE_COUNT (system data metric function)
• EXTREME_OUTLIER_ZSCORE_PERCENT (system data metric function)
• FALSE_COUNT (system data metric function)
• FALSE_PERCENT (system data metric function)
• FRESHNESS (system data metric function)
• FUTURE_TIMESTAMP_COUNT (system data metric function)
• FUTURE_TIMESTAMP_PERCENT (system data metric function)
• GEOMETRIC_MEAN (system data metric function)
• HARMONIC_MEAN (system data metric function)
• INVALID_CA_POSTAL_CODE_COUNT (system data metric function)
• INVALID_CA_POSTAL_CODE_PERCENT (system data metric function)
• INVALID_CA_SIN_COUNT (system data metric function)
• INVALID_CA_SIN_PERCENT (system data metric function)
• INVALID_CH_OASI_COUNT (system data metric function)
• INVALID_CH_OASI_PERCENT (system data metric function)
• INVALID_CUSIP_COUNT (system data metric function)
• INVALID_CUSIP_PERCENT (system data metric function)
• INVALID_DE_POSTAL_CODE_COUNT (system data metric function)
• INVALID_DE_POSTAL_CODE_PERCENT (system data metric function)
• INVALID_DE_TAX_ID_COUNT (system data metric function)
• INVALID_DE_TAX_ID_PERCENT (system data metric function)
• INVALID_EMAIL_COUNT (system data metric function)
• INVALID_EMAIL_PERCENT (system data metric function)
• INVALID_ES_DNI_COUNT (system data metric function)
• INVALID_ES_DNI_PERCENT (system data metric function)
• INVALID_FIGI_COUNT (system data metric function)
• INVALID_FIGI_PERCENT (system data metric function)
• INVALID_FR_INSEE_CODE_COUNT (system data metric function)
• INVALID_FR_INSEE_CODE_PERCENT (system data metric function)
• INVALID_FR_POSTAL_CODE_COUNT (system data metric function)
• INVALID_FR_POSTAL_CODE_PERCENT (system data metric function)
• INVALID_INTEGER_COUNT (system data metric function)
• INVALID_INTEGER_PERCENT (system data metric function)
• INVALID_ISIN_COUNT (system data metric function)
• INVALID_ISIN_PERCENT (system data metric function)
• INVALID_ISO8601_FORMAT_COUNT (system data metric function)
• INVALID_ISO8601_FORMAT_PERCENT (system data metric function)
• INVALID_IT_FISCAL_CODE_COUNT (system data metric function)
• INVALID_IT_FISCAL_CODE_PERCENT (system data metric function)
• INVALID_JSON_COUNT (system data metric function)
• INVALID_JSON_PERCENT (system data metric function)
• INVALID_LATITUDE_COUNT (system data metric function)
• INVALID_LATITUDE_PERCENT (system data metric function)
• INVALID_LEI_COUNT (system data metric function)
• INVALID_LEI_PERCENT (system data metric function)
• INVALID_LONGITUDE_COUNT (system data metric function)
• INVALID_LONGITUDE_PERCENT (system data metric function)
• INVALID_NL_BSN_COUNT (system data metric function)
• INVALID_NL_BSN_PERCENT (system data metric function)
• INVALID_NUMERIC_TYPE_CAST_COUNT (system data metric function)
• INVALID_NUMERIC_TYPE_CAST_PERCENT (system data metric function)
• INVALID_PERCENTAGE_RANGE_COUNT (system data metric function)
• INVALID_PERCENTAGE_RANGE_PERCENT (system data metric function)
• INVALID_PERM_ID_COUNT (system data metric function)
• INVALID_PERM_ID_PERCENT (system data metric function)
• INVALID_PL_PESEL_COUNT (system data metric function)
• INVALID_PL_PESEL_PERCENT (system data metric function)
• INVALID_PROBABILITY_RANGE_COUNT (system data metric function)
• INVALID_PROBABILITY_RANGE_PERCENT (system data metric function)
• INVALID_SEDOL_COUNT (system data metric function)
• INVALID_SEDOL_PERCENT (system data metric function)
• INVALID_TIMESTAMP_STRING_COUNT (system data metric function)
• INVALID_TIMESTAMP_STRING_PERCENT (system data metric function)
• INVALID_TR_ID_NO_COUNT (system data metric function)
• INVALID_TR_ID_NO_PERCENT (system data metric function)
• INVALID_UK_NINO_COUNT (system data metric function)
• INVALID_UK_NINO_PERCENT (system data metric function)
• INVALID_UK_POSTAL_CODE_COUNT (system data metric function)
• INVALID_UK_POSTAL_CODE_PERCENT (system data metric function)
• INVALID_USA_PHONE_COUNT (system data metric function)
• INVALID_USA_PHONE_PERCENT (system data metric function)
• INVALID_USA_STATE_CODE_COUNT (system data metric function)
• INVALID_USA_STATE_CODE_PERCENT (system data metric function)
• INVALID_USA_ZIP_CODE_COUNT (system data metric function)
• INVALID_USA_ZIP_CODE_PERCENT (system data metric function)
• INVALID_UUID_COUNT (system data metric function)
• INVALID_UUID_PERCENT (system data metric function)
• KURTOSIS (system data metric function)
• MAE (system data metric function)
• MAPE (system data metric function)
• MAX (system data metric function)
• MEAN_ERROR (system data metric function)
• MEDIAN (system data metric function)
• MIN (system data metric function)
• NAN_COUNT (system data metric function)
• NAN_PERCENT (system data metric function)
• NEGATIVE_COUNT (system data metric function)
• NEGATIVE_PERCENT (system data metric function)
• NOT_FRIDAY_COUNT (system data metric function)
• NOT_FRIDAY_PERCENT (system data metric function)
• NOT_IN_FUTURE_COUNT (system data metric function)
• NOT_IN_FUTURE_PERCENT (system data metric function)
• NOT_MONDAY_COUNT (system data metric function)
• NOT_MONDAY_PERCENT (system data metric function)
• NOT_NULL_COUNT (system data metric function)
• NOT_NULL_PERCENT (system data metric function)
• NOT_SATURDAY_COUNT (system data metric function)
• NOT_SATURDAY_PERCENT (system data metric function)
• NOT_SUNDAY_COUNT (system data metric function)
• NOT_SUNDAY_PERCENT (system data metric function)
• NOT_THURSDAY_COUNT (system data metric function)
• NOT_THURSDAY_PERCENT (system data metric function)
• NOT_TODAY_COUNT (system data metric function)
• NOT_TODAY_PERCENT (system data metric function)
• NOT_TUESDAY_COUNT (system data metric function)
• NOT_TUESDAY_PERCENT (system data metric function)
• NOT_WEDNESDAY_COUNT (system data metric function)
• NOT_WEDNESDAY_PERCENT (system data metric function)
• NOT_WEEKDAY_COUNT (system data metric function)
• NOT_WEEKDAY_PERCENT (system data metric function)
• NOT_YESTERDAY_COUNT (system data metric function)
• NOT_YESTERDAY_PERCENT (system data metric function)
• NULL_COUNT (system data metric function)
• NULL_KEYWORD_COUNT (system data metric function)
• NULL_KEYWORD_PERCENT (system data metric function)
• NULL_PERCENT (system data metric function)
• OUTLIER_COUNT (system data metric function)
• OUTLIER_IQR_COUNT (system data metric function)
• OUTLIER_IQR_PERCENT (system data metric function)
• OUTLIER_PERCENT (system data metric function)
• OUTLIER_ZSCORE_COUNT (system data metric function)
• OUTLIER_ZSCORE_PERCENT (system data metric function)
• R_SQUARED (system data metric function)
• REFERENTIAL_INTEGRITY_COUNT (system data metric function)
• RMSE (system data metric function)
• ROW_COUNT (system data metric function)
• ROWS_IN_PAST_DAY_COUNT (system data metric function)
• ROWS_IN_PAST_DAY_PERCENT (system data metric function)
• ROWS_IN_PAST_HOUR_COUNT (system data metric function)
• ROWS_IN_PAST_HOUR_PERCENT (system data metric function)
• ROWS_IN_PAST_MONTH_COUNT (system data metric function)
• ROWS_IN_PAST_MONTH_PERCENT (system data metric function)
• ROWS_IN_PAST_WEEK_COUNT (system data metric function)
• ROWS_IN_PAST_WEEK_PERCENT (system data metric function)
• ROWS_IN_PAST_YEAR_COUNT (system data metric function)
• ROWS_IN_PAST_YEAR_PERCENT (system data metric function)
• SCHEMA_CHANGE_ADD_COUNT (system data metric function)
• SCHEMA_CHANGE_COUNT (system data metric function)
• SCHEMA_CHANGE_DROP_COUNT (system data metric function)
• SCHEMA_CHANGE_TYPE_COUNT (system data metric function)
• SKEW (system data metric function)
• SOURCE_TARGET_LAG (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)
• STRING_LENGTH_STDDEV (system data metric function)
• SUM (system data metric function)
• TABLE_SIZE_BYTES (system data metric function)
• TRUE_COUNT (system data metric function)
• TRUE_PERCENT (system data metric function)
• UNIQUE_COUNT (system data metric function)
• UNIQUE_PERCENT (system data metric function)
• UNIX_ZERO_COUNT (system data metric function)
• UNIX_ZERO_PERCENT (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.