19
Accepted answer
Document the grain decision, most BI bugs turn out to be grain bugs.
This worked in dev on sample data but fails at full volume. Details:
Context: Great Expectations vs dbt tests for pipeline contracts
Happy to share schema snippets or metrics if useful.
Accepted answer
Document the grain decision, most BI bugs turn out to be grain bugs.
Start with the execution plan, numbers beat guesses.
Idempotent writes with merge keys saved us during backfills.
Sign in to reply.