Skip to content

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;

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 rule
SELECT 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.

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 →