Field note · April 26, 2024
Pattern: The grain uniqueness test
One test per model, on the key that defines its grain. The cheapest quality control available and the one that catches the worst bugs.
The shape: The grain sentence, written as an assertion that runs. — that is The grain uniqueness test, and it comes up more than it should.
One test per model, on the key that defines its grain. The cheapest quality control available and the one that catches the worst bugs.
What makes it a pattern rather than a tip is that the wrong version is the one you write naturally. It reads correctly, it runs, and it returns something. The failure is in the result, not in the execution — which means the only defence is recognising the shape before you are in it.
Two datasets on this site have the shape built in: retail-orders and support-tickets. Both are small enough to run the broken version, see the number, then run the corrected one and see it change.
It lives under moving because it is about data in transit: reruns, backfills, and the assumption that yesterday only ever arrives once.
The long-form treatment is in the course (testing-data-like-code, rows-grain-shape); the pattern page is the version to read at 4pm with a query open.
If you have a better formulation of this one, the repository takes issues. Several entries there are sharper than what we started with because someone pushed back.