cardinality_equality.sql

{% macro test_cardinality_equality(model, from, to, field) %}

with table_a as (
select
  {{ from }},
  count(*) as num_rows
from {{ model }}
group by 1
),

table_b as (
select
  {{ field }},
  count(*) as num_rows
from {{ to }}
group by 1
),

except_a as (
  select *
  from table_a
  except
  select *
  from table_b
),

except_b as (
  select *
  from table_b
  except
  select *
  from table_a
),

unioned as (
  select *
  from except_a
  union all
  select *
  from except_b
)

select count(*)
from unioned

{% endmacro %}