Great Expectations vs dbt tests for pipeline contracts

Could you share a sketch of the salting logic?

Idempotent writes with merge keys saved us during backfills.

Prefer a staging table plus validation gate before promoting to prod tables.

Worth measuring the serialized size before choosing broadcast.

In our case the root cause was an implicit cast preventing pushdown.

What batch size or interval worked for you at similar scale?

ELI5 version: it's not broken, it's just slow because it's checking way more stuff than it needs to. Narrowing what it checks is almost always the fix.

We saw the same issue, fixing the partition filter dropped runtime 60%.