Module Contents


ExpectColumnSumToBeBetween(configuration: Optional[ExpectationConfiguration] = None)

Expect the column to sum to be between an min and max value

class great_expectations.expectations.core.expect_column_sum_to_be_between.ExpectColumnSumToBeBetween(configuration: Optional[ExpectationConfiguration] = None)

Bases: great_expectations.expectations.expectation.ColumnExpectation

Expect the column to sum to be between an min and max value

expect_column_sum_to_be_between is a :func:`column_aggregate_expectation



column (str): The column name min_value (comparable type or None): The minimal sum allowed. max_value (comparable type or None): The maximal sum allowed. strict_min (boolean):

If True, the minimal sum must be strictly larger than min_value, default=False

strict_max (boolean):

If True, the maximal sum must be strictly smaller than max_value, default=False

Other Parameters:
result_format (str or None): Which output mode to use: BOOLEAN_ONLY, BASIC, COMPLETE, or SUMMARY.

For more detail, see result_format.

include_config (boolean): If True, then include the expectation config as part of the result object. For more detail, see include_config. catch_exceptions (boolean or None): If True, then catch exceptions and include them as part of the result object. For more detail, see catch_exceptions. meta (dict or None): A JSON-serializable dictionary (nesting allowed) that will be included in the output without modification. For more detail, see meta.


An ExpectationSuiteValidationResult

Exact fields vary depending on the values passed to result_format and include_config, catch_exceptions, and meta.


These fields in the result object are customized for this expectation:

    "observed_value": (list) The actual column sum
  • min_value and max_value are both inclusive unless strict_min or strict_max are set to True.

  • If min_value is None, then max_value is treated as an upper bound

  • If max_value is None, then min_value is treated as a lower bound

metric_dependencies = ['column.sum']
success_keys = ['min_value', 'strict_min', 'max_value', 'strict_max']
args_keys = ['column', 'min_value', 'max_value', 'strict_min', 'strict_max']

A Column Map Metric Decorator for the Sum

validate_configuration(self, configuration: Optional[ExpectationConfiguration])

Validates that a configuration has been set, and sets a configuration if it has yet to be set. Ensures that necessary configuration arguments have been provided for the validation of the expectation.


configuration (OPTIONAL[ExpectationConfiguration]) – An optional Expectation Configuration entry that will be used to configure the expectation


True if the configuration has been validated successfully. Otherwise, raises an exception

classmethod _atomic_prescriptive_template(cls, configuration=None, result=None, language=None, runtime_configuration=None, **kwargs)

Template function that contains the logic that is shared by atomic.prescriptive.summary (GE Cloud) and renderer.prescriptive (OSS GE)

classmethod _prescriptive_renderer(cls, configuration=None, result=None, language=None, runtime_configuration=None, **kwargs)
_validate(self, configuration: ExpectationConfiguration, metrics: Dict, runtime_configuration: dict = None, execution_engine: ExecutionEngine = None)