snowflake.snowpark.functions.dp_interval_low¶

snowflake.snowpark.functions.dp_interval_low(aggregated_column: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.41.0/src/snowflake/snowpark/_functions/scalar_functions.py#L938-L958)¶

Returns the lower bound of the confidence interval for a differentially private aggregate. This function is used with differential privacy aggregation functions to provide statistical bounds on the results.

Parameters:

aggregated_column (ColumnOrName) – The differentially private aggregate result.

Returns:

The lower bound of the confidence interval.

Return type:

Column

Example:

>>> from snowflake.snowpark.functions import sum as sum_
>>> df = session.create_dataframe([[10], [20], [30]], schema=["num_claims"])
>>> result = df.select(sum_("num_claims").alias("sum_claims")).select(dp_interval_low("sum_claims").alias("interval_low"))
>>> result.collect()
[Row(INTERVAL_LOW=None)]

Copy