The hardware and bandwidth for this mirror is donated by dogado GmbH, the Webhosting and Full Service-Cloud Provider. Check out our Wordpress Tutorial.
If you wish to report a bug, or if you are interested in having us mirror your free-software or open-source project, please feel free to contact us at mirror[@]dogado.de.

dqcheckr 0.2.1

Bug fixes

• Report and drift filename slugs now use UTC consistently, matching the UTC timestamps stored in the snapshot DB.
• Removed redundant @importFrom declarations for template-only packages.
• Removed dead read_pass_rate_trend() function from drift.R.
• CP-07 type-change comparison now uses a single guard so it only runs the non-numeric rate comparison when both snapshots classify the column as numeric — eliminates spurious WARNs on type-changed columns.
• read_dataset() now forwards the col_names config key to readr::read_delim(), so headerless CSVs are read correctly.
• read_dataset() now forwards the quote_char config key to readr::read_delim() as quote =.

Internal

• All rlang::abort() calls (27 sites) now carry a typed, two-level class hierarchy (c("<specific>", "dqcheckr_error")), letting callers catch errors broadly or precisely.
• Consolidated shared test fixtures into helper.R.

dqcheckr 0.2.0

New features

• New compare_snapshots() and list_snapshots() functions for drift analysis. Compares any two historical snapshots and optionally renders an HTML drift report with per-column statistical drift, schema changes, and trend charts.
• New resolve_col_type() function: returns the effective type for a column, respecting per-column type overrides set in the column_types config key.
• New QC-15 outlier detection check (check_outliers()). Configured via max_z_score and/or iqr_fence_multiplier; skipped silently when neither is set.
• check_key_uniqueness() (QC-12) now supports composite keys: set key_columns to a character vector in the dataset YAML.
• check_min_row_count() (QC-14) gains max_row_count and max_file_size_mb thresholds.
• col_threshold() and table_threshold() added as internal helpers; column_rules per-column threshold overrides are now correctly stored in column_snapshots.threshold (G-01).

Behaviour changes

• Reports migrated from rmarkdown to Quarto. render_report() uses quarto::quarto_render() and returns NULL with a warning when Quarto CLI is not installed.
• compare_schema() (CP-02) split into three separate result objects: CP-02a (new columns), CP-02b (dropped columns), CP-02c (type changes).
• compare_non_numeric_rate() (CP-07) now always emits a result for every eligible column, including PASS for columns where the rate did not increase (G-02).
• run_timestamp is now stored in ISO-8601 UTC format (2026-01-01T12:00:00Z) rather than local time (RC-07).
• snapshots table gains three columns on first use: comparison_mode, render_status, and type_changed_cols_vs_previous. Existing 0.1.x databases are auto-migrated on the first 0.2.0 run.
• SQLite foreign key enforcement is now explicitly enabled on every connection (PRAGMA foreign_keys = ON).
• detect_files() uses filename as a secondary sort when two files share the same modification time, making folder-mode ordering deterministic (RC-01).
• check_allowed_values() (QC-09), compare_new_values() (CP-05), and compare_dropped_values() (CP-06) cap observed at 20 values with an "... and N more" suffix (RC-04, RC-05).
• check_non_numeric() (QC-11) gains a warn_non_numeric_rate config key for a separate WARN threshold (C-01).
• compare_missing_rate() (CP-03) gains a missing_rate_change_severity config key (warn / fail) (B-07).
• compare_column_order() (CP-08) gains a column_order_severity config key that overrides the format-based default (C-02).
• compute_col_stats() stores the numeric mean under the key numeric_parseable_mean (renamed from numeric_mean) to clarify that non-parseable values are excluded from the calculation (C-04).
• Comparison summary in the HTML report now lists all FAIL/WARN messages as a bullet list rather than picking the single worst result (C-05).
• compare_snapshots() uses the full merged per-dataset config for drift threshold comparisons, so *** markers match the original check run for datasets with rule_overrides (G-05/G-06).
• compute_col_stats() unused qc_results parameter removed (D-01).

dqcheckr 0.1.1

• flag_new_columns, flag_dropped_columns, flag_type_changes (in CP-02) and flag_column_order_change (CP-08) are now honoured. Setting any flag to false suppresses the corresponding check from the report. Schema changes are still tracked in the SQLite snapshot regardless of flags.
• type_inference_threshold is now configurable per dataset via rule_overrides in the dataset YAML (or default_rules in the global config). Previously fixed at 90%, it now defaults to 90% if not set. Affects QC-06, QC-07, QC-08, QC-11, CP-02, CP-04, CP-05, CP-06, and CP-07.

dqcheckr 0.1.0

Initial release.

• Single-snapshot quality checks: QC-01 to QC-14 (missing rate, empty columns, duplicate rows, row/column counts, inferred types, numeric stats, distinct counts, allowed values, numeric bounds, non-numeric rate, key uniqueness, regex pattern, minimum row count) and SC-01/SC-02 (schema contract).
• Version comparison checks: CP-01 to CP-08 (row count change, schema diff, missing rate change, numeric mean shift, new/dropped distinct values, non-numeric rate change, column order).
• Custom organisation-specific checks via a plain R file.
• Self-contained HTML report with check tables, historical trend charts, and column statistics appendix.
• SQLite snapshot database for long-term trend tracking.
• Supports CSV and fixed-width (FWF) file formats.
• Configuration via global dqcheckr.yml and per-dataset YAML files.

These binaries (installable software) and packages are in development.
They may not be fully stable and should be used with caution. We make no claims about them.
Health stats visible at Monitor.