anofox-tabular
Browser: precomputed results
Native: community extension and full toolkit
anofox-tabular — data profiling, data-quality checks, anomaly scores, PII detection, diffs and deduplication for tables in DuckDB.
INSTALL anofox_tabular FROM community;LOAD anofox_tabular; LOAD anofox_visualization;Plot its results
Section titled “Plot its results”The suite check already returns the check schema, so it plots as it comes; a profile’s correlations plot as a matrix:
SELECT anofox_plot(t) FROM anofox_tab_run_checks('checks') t; -- a check band per ruleSELECT anofox_plot_matrix(t) FROM anofox_tab_profile_correlations('d') t; -- a correlation matrix| Output | Plotted by |
|---|---|
anofox_tab_run_checks, anofox_tab_agg_check |
anofox_plot_checks |
| profile correlations | anofox_plot_matrix |
one-row checks (null_rate, compliance, …) |
anofox_plot_summary, after a reshape |
| time-aware checks | anofox_plot_events |
anofox_plot(t) picks the macro from the table’s columns. The macros are aggregates: GROUP BY gives one SVG per group.
In the builder
Section titled “In the builder”- Is today’s supplier feed safe to load?
- Can we switch on the new CRM?
- Which duplicate customers should we merge?
Checked in CI
Section titled “Checked in CI”Every producer of the extension’s latest build is plotted on every push (scripts/tabular_conformance.py): a SQL error, a missing SVG or a producer without a recipe fails the run. Reference →