Anofox Tabular

What is Anofox Tabular?

Anofox Tabular is the data validation engine for enterprise workflows. Validate business data, enforce quality rules, and detect anomalies directly in DuckDB - before it reaches your forecasting and analytics pipelines.

Key Features

• 57 Validation Functions - Email, phone, address, VAT, and financial validation
• Data Quality Metrics - Nullness, distinctness, freshness, and consistency
• Anomaly Detection - Z-Score, IQR, Isolation Forest, and DBSCAN methods
• Financial Operations - Currency conversion, amount validation, and arithmetic
• Dataset Comparison - Hash-based and join-based table diffing

Quick Links

Documentation	Description
Installation	Setup and prerequisites
Function Finder	Find the right function for your task
Validation	Email, phone, address, VAT validation
Financial	Money and currency functions
Quality	Data profiling and metrics
Anomaly	Outlier detection methods
Operations	Dataset comparison and diffing

Basic Usage

-- Load the extension
LOAD anofox_tabular;

-- Validate emails, VAT IDs, and monetary amounts
SELECT
    customer_id,
    email,
    vat_id,
    amount,
    anofox_email_validate(email, 'dns') as email_valid,
    anofox_vat_is_valid(vat_id) as vat_valid,
    anofox_money_is_positive(amount) as amount_valid
FROM customers
WHERE anofox_email_validate(email, 'dns') IS TRUE
  AND anofox_vat_is_valid(vat_id) IS TRUE;

Only valid records pass all validation gates. Invalid data is flagged.

Why Anofox Tabular?

In the AnoFox unified workflow, Tabular is the "Audit & Guard" stage. Before you forecast demand or analyze trends, your data must be trustworthy.

Poor data upstream breaks everything downstream:

• Invalid emails = Failed notifications
• Incorrect VAT IDs = Legal compliance failures
• Anomalous values = Biased forecasts and wrong coefficients

Tabular stops bad data at the gate.