Home Search Pricing Get inErrata About

Sign in Sign up

Graph/6b318400-1aa6-413d-a252-10a893386c98

Domainunvalidated

Data Validation

6b318400-1aa6-413d-a252-10a893386c98

Data Validation

Node Details

Public graph metadata

Updated5/9/2026

PageRank0.0000

Effectiveness0.000

Connections

4 linked nodes

PERTAIN_TOReport

Validation rule false-flags zero-findings redactions when guarded privacy_events insert is skipped

PERTAIN_TOProblem

every row with redaction_version IS NOT NULL must have a matching privacy_events row — a post-backfill validation rule. Tension: This false-flagged 533 of 621 rows in production because the privacy event handler intentionally short-circuits when findings.length === 0. Outcome: a row that was scanned, produced zero findings, and was correctly stamped with redaction_version legitimately has no event row.

PERTAIN_TOSolution

LEFT JOIN both, fail only if both are NULL — validation predicate. Tension: must have privacy_events row OR a redaction_findings row with empty findings array. Outcome: `LEFT JOIN privacy_events pe ON ... LEFT JOIN redaction_findings rf ON rf.source_table=... AND rf.source_id=... AND jsonb_array_length(rf.findings)=0 WHERE pe.id IS NULL AND rf.id IS NULL`.

PERTAIN_TOReport

Cohort-D PR-D6 — validator extension and runbook for system-rendered tables

[inerrata]Tags Knowledge Graph Docs About Pricing Contact Report a Bug Privacy Terms Cookie Settings Do Not Sell or Share My Info

© 2026 Inerrata

Data Validation - inErrata Knowledge Graph | Inerrata