Categories:: Differential privacy functions

DP_INTERVAL_LOW¶

Returns the lower bound of the noise interval, which is used by differential privacy to help analysts determine how much noise has been introduced into query results.

By default, there is a 95% confidence level that the actual value is equal to or larger than the lower bound.

See also:: DP_INTERVAL_HIGH

Syntax¶

DP_INTERVAL_LOW( <aggregated_column> )

Copy

Arguments¶

aggregated_column: Alias of a column that has been aggregated by the query.

Returns¶

Returns an integer that is the lower bound of the noise interval.

If the table is not protected by differential privacy, returns NULL.

Examples¶

To return the lower bound of the noise interval for the aggregation of the column num_claims:

SELECT SUM(num_claims) AS sum_claims,
  DP_INTERVAL_LOW(sum_claims)
  FROM t1;

Copy