Categories:: Data metric functions

NEGATIVE_COUNT (system data metric function)¶

Returns the count of column values that are negative for the specified column in a table. Use this function to validate columns that should never be negative, such as price, quantity, or age.

This topic provides the syntax for calling the function directly. To learn how to associate the function with a table or view so it runs at regular intervals, see Associate a DMF.

Syntax¶

SNOWFLAKE.CORE.NEGATIVE_COUNT(<query>)

Arguments¶

query: Specifies a SQL query that projects a single column.

Allowed data types¶

The column projected by the query must have one of the following data types:

FLOAT
NUMBER

Returns¶

The function returns a NUMBER value. NULL values are not counted as negative.

Example¶

Measure the number of negative values in the price column:

SELECT SNOWFLAKE.CORE.NEGATIVE_COUNT(
  SELECT
    price
  FROM sales.tables.products
);