@davidclarance maybe you can help me with this? happy to give more context later -- just jotting this down for now
test's compiled SQL
-- setup
with a as (
select * from "dbt-msft-serverless-db"."test"."test_insert_by_period"
),
b as (
select * from "dbt-msft-serverless-db"."test"."expected_insert_by_period"
),
a_minus_b as (
select "id", "created_at" from a
except
select "id", "created_at" from b
),
b_minus_a as (
select "id", "created_at" from b
except
select "id", "created_at" from a
),
unioned as (
select 'a_minus_b' as which_diff, * from a_minus_b
union all
select 'b_minus_a' as which_diff, * from b_minus_a
)
select * from unioned
@davidclarance maybe you can help me with this? happy to give more context later -- just jotting this down for now
test's compiled SQL
results