Recall how to choose and explain basic dbt data tests.
What does a not_null test protect? A required field contract. Use it for identifiers, timestamps, and fields consumers cannot interpret when missing. What does a unique test protect? The declared grain of the model. It only makes sense after you know the one-row-per promise. Objection The test is flaky, can we delete it? Say this Let’s inspect whether the assumption is wrong, the source is late, or the test threshold needs changing. Deleting it removes the only signal. Confusing noisy evidence with useless evidence. It keeps the quality conversation anchored in the assumption. Generic or singular test? Start generic; write…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in