Skip to content

Latest commit

 

History

History
14 lines (11 loc) · 518 Bytes

expect_multicolumn_sum_to_equal.md

File metadata and controls

14 lines (11 loc) · 518 Bytes

expect_multicolumn_sum_to_equal (source)

Expects that sum of all rows for a set of columns is equal to a specific value

Applies to: Model, Seed, Source

tests:
  - dbt_expectations.expect_multicolumn_sum_to_equal:
      column_list: ["col_numeric_a", "col_numeric_b"]
      sum_total: 4
      group_by: [group_id, other_group_id, ...] # (Optional)
      row_condition: "id is not null" # (Optional)