Great Expectations vs dbt tests for pipeline contracts

Start with the execution plan, numbers beat guesses.

Sometimes the real fix is a product change so you stop needing that join at all.

Any downside to this approach with incremental models?

Idempotent writes with merge keys saved us during backfills.

Document the grain decision, most BI bugs turn out to be grain bugs.