Skip to content

Default value

numeric_default_value - Column-level - Numeric

Validates that non-null values in a column match an expected default value.

Parameters

Parameter Type Default Required Description
expected_value float none Yes The value non-null rows are expected to match.
threshold_percent float 0.0 No Fail if the percentage of non-matching values exceeds this.

YAML example

checks:
  - name: example_numeric_default_value
    check_type: numeric_default_value
    table_name: schema.table
    column_name: example_column
    parameters:
      expected_value: <expected_value>
      threshold_percent: 0.0

See YAML check format for the full field reference.