About data tests property¶
Labs, d. About data tests property. dbt Developer Hub.
Cited by¶
1 citation across 1 artifact.
Each citation links to the sentence it supports in the citing article.
Mechanisms¶
- Relational Integrity Test Suite
- … every `account` must have exactly one `owning_rep` (a duplicate-owner test); every `contact.account_id` must match an existing account (an orphan test, the same relationship check that dbt's built-in `relationships` test performs); and no account may be simultaneously `active` and `churned` (a forbidden-pairing test).
This sourceDefines dbt's relationships data test as verifying that every value in a child field exists in a referenced parent field, i.e. referential integrity.
- … every `account` must have exactly one `owning_rep` (a duplicate-owner test); every `contact.account_id` must match an existing account (an orphan test, the same relationship check that dbt's built-in `relationships` test performs); and no account may be simultaneously `active` and `churned` (a forbidden-pairing test).
Verification¶
Does it exist? Not checked yet. This entry carries no identifier to resolve. It was extracted from the citation as written in the article, normalized, and deduplicated against the rest of the registry.
Does it back the claim? Not recorded. The single citation of this work carries no recorded support check.
Support is checked per citation rather than per work — the same source can be cited soundly in one article and wrongly in another. Per-citation recording began recently, so a citation with no recorded check is a gap in the record rather than evidence it went unchecked.
See how references were verified.
Registry ID ref:6a8080d5048b · see in the full table