{% extends "base.html" %} {% block title %}Data Quality — Data Canvas — ICDEV{% endblock %} {% block content %}
Dashboard Explore Query Quality Assessments

Data Quality Rules

Define completeness, uniqueness, range, pattern, and freshness expectations. Run checks — results feed the Assessment engine (DDC-QUA-001).

Quality Score

{% set score = quality_score %} {% if score is not none %} {% set score_class = 'score-green' if score >= 70 else ('score-orange' if score >= 40 else 'score-red') %} {% set stroke_color = '#66bb6a' if score >= 70 else ('#ff9800' if score >= 40 else '#ef5350') %} {% set circumference = 283 %} {% set dash = (score / 100 * circumference) | round(1) %}
{{ score | round(0) | int }}%
quality

Based on {{ runs | length }} recent rule runs

{% else %}
—
no runs yet

Run quality checks to see your score.

{% endif %}

Add Rule

Rules

[connection params for Run All]
{% if rules %} {% for r in rules %} {% endfor %}
NameTable.ColumnCheckThresholdEnabled
{{ r.name }} {{ r.table_name }}{% if r.column_name %}.{{ r.column_name }}{% endif %} {{ r.check_type }} {{ r.threshold }}{% if r.check_type in ['completeness','uniqueness','pattern'] %}%{% endif %}
{% else %}
No quality rules yet. Add one above.
{% endif %}

Freshness Monitor

Hourly reflex results for all freshness quality rules (via FreshnessGuardianReflex). Alerts sourced from dd_freshness_alerts.

{% if freshness_alerts %} {% for a in freshness_alerts %} {% endfor %}
RuleDesignMax ValueCutoffStatusDetailChecked
{{ a.rule_name or a.rule_id }} {{ a.design_id or '—' }} {{ a.actual_max_value or '—' }} {{ a.cutoff_value or '—' }} {{ '✓ PASS' if a.passed else '✗ BREACH' }} {{ a.detail or '—' }} {{ a.last_checked[:16] if a.last_checked else (a.created_at[:16] if a.created_at else '—') }}
{% else %}
No freshness alerts yet. The FreshnessGuardianReflex runs hourly and will populate this table once freshness rules are defined and checked.
{% endif %}

Run History

{% if runs %} {% for r in runs %} {% endfor %}
RuleTable.ColTypeResultActualThresholdDetailWhen
{{ r.rule_name or r.rule_id }} {{ r.table_name or '—' }}{% if r.column_name %}.{{ r.column_name }}{% endif %} {{ r.check_type or '—' }} {{ '✓ PASS' if r.passed else '✗ FAIL' }} {{ '%.1f'|format(r.actual_value or 0) }} {{ r.threshold }} {{ r.detail }} {{ r.created_at[:16] if r.created_at else '—' }}
{% else %}
No runs yet. Click Run All to evaluate your rules.
{% endif %}
{% endblock %}