audit-dim-joins

What problem does it solve?

Validate and annotate the joins between fact and dimension tables to ensure accurate aggregations, surface join gaps, and provide actionable notes for per-table and subject-level documentation.

Core Features & Use Cases

• Detect and rate the accuracy of dimension joins for a given fact table.
• Surface unmatched codes, join gaps, and potential hierarchy level issues to guide remediation.
• Integrate with the audit CLI (audit-dim-joins.py) and encourage validation via psql, alongside generating notes for both fact docs and subject docs.
• Support iterative improvements by updating dimension_links or notes based on audit findings.

Quick Start

Run the audit on a subject with uv run python scripts/audit_dim_joins.py audit-subject <subject_path> to generate match rates and notes.