Function Finder

Quick reference for all 78 Tabular functions.

Categories

Validation

Email, phone, VAT, and address validation APIs

emailphoneVATpostal+22 more

Financial

Money amounts, currency validation, and conversion

moneycurrencyconvertformat+13 more

PII Detection

Detect and mask personal data in text

detectmaskscanvalidate+16 more

Quality

Data profiling and quality metrics

nullnessdistinctnessfreshnessvolume

Anomaly

Statistical and ML outlier detection

Z-ScoreIQRIsolationForestOutlierTree

Operations

Dataset comparison and diffing functions

diff_hashdiff_join

All Functions

All CategoryAddressAnomalyCurrencyEmailMoneyOperationsPIIPhoneQualityVAT

Function	Description	SQL Signature	Category
anofox_tab_email_is_valid	Validate email	(email, mode) -> BOOLEAN	Email
anofox_tab_email_validate	Detailed validation	(email, mode) -> STRUCT	Email
anofox_tab_email_config	Show config	() -> TABLE	Email
anofox_tab_postal_parse_address	Parse address	(address) -> STRUCT	Address
anofox_tab_postal_expand_address	Expand variants	(address) -> LIST	Address
anofox_tab_postal_status	Library status	() -> TABLE	Address
anofox_tab_postal_load_data	Download data	() -> BOOLEAN	Address
anofox_tab_phonenumber_parse	Parse number	(number, region) -> STRUCT	Phone
anofox_tab_phonenumber_format	Format number	(number, region, format) -> VARCHAR	Phone
anofox_tab_phonenumber_region	Get region	(number, region) -> VARCHAR	Phone
anofox_tab_phonenumber_is_valid	Validate full	(number, region) -> BOOLEAN	Phone
anofox_tab_phonenumber_is_possible	Quick check	(number, region) -> BOOLEAN	Phone
anofox_tab_phonenumber_is_valid_for_region	Region-specific	(number, region) -> BOOLEAN	Phone
anofox_tab_phonenumber_match	Fuzzy match	(num1, num2, region) -> VARCHAR	Phone
anofox_tab_phonenumber_example	Example number	(region) -> VARCHAR	Phone
anofox_tab_phonenumber_status	Library status	() -> TABLE	Phone
anofox_tab_money	Create money	(amount, currency) -> STRUCT	Money
anofox_tab_money_from_cents	From cents	(cents, currency) -> STRUCT	Money
anofox_tab_money_amount	Extract amount	(money) -> DOUBLE	Money
anofox_tab_money_currency	Extract currency	(money) -> VARCHAR	Money
anofox_tab_money_format	Format display	(money, style) -> VARCHAR	Money
anofox_tab_money_is_positive	Check positive	(money) -> BOOLEAN	Money
anofox_tab_money_is_negative	Check negative	(money) -> BOOLEAN	Money
anofox_tab_money_is_zero	Check zero	(money) -> BOOLEAN	Money
anofox_tab_money_abs	Absolute value	(money) -> STRUCT	Money
anofox_tab_money_add	Add amounts	(money1, money2) -> STRUCT	Money
anofox_tab_money_subtract	Subtract	(money1, money2) -> STRUCT	Money
anofox_tab_money_multiply	Multiply	(money, factor) -> STRUCT	Money
anofox_tab_money_in_range	Check range	(money, min, max) -> BOOLEAN	Money
anofox_tab_money_same_currency	Same currency	(money1, money2) -> BOOLEAN	Money
anofox_tab_is_valid_currency	Valid code	(code) -> BOOLEAN	Currency
anofox_tab_currency_symbol	Get symbol	(code) -> VARCHAR	Currency
anofox_tab_currency_name	Get name	(code) -> VARCHAR	Currency
anofox_tab_vat	Parse VAT	(vat) -> STRUCT	VAT
anofox_tab_vat_is_valid	Full validation	(vat) -> BOOLEAN	VAT
anofox_tab_vat_is_valid_syntax	Syntax check	(vat) -> BOOLEAN	VAT
anofox_tab_vat_normalize	Normalize	(vat) -> VARCHAR	VAT
anofox_tab_vat_split	Split parts	(vat) -> STRUCT	VAT
anofox_tab_vat_exists	Valid prefix	(vat) -> BOOLEAN	VAT
anofox_tab_vat_is_eu_member	EU member	(country) -> BOOLEAN	VAT
anofox_tab_vat_country_name	Country name	(code) -> VARCHAR	VAT
anofox_tab_vat_format	Format	(vat, style) -> VARCHAR	VAT
anofox_tab_is_valid_vat_country	Valid country	(code) -> BOOLEAN	VAT
anofox_tab_pii_detect	Detect all PII	(text) -> VARCHAR	PII
anofox_tab_pii_mask	Mask PII	(text, strategy) -> VARCHAR	PII
anofox_tab_pii_contains	Has PII?	(text) -> BOOLEAN	PII
anofox_tab_pii_count	Count PII	(text) -> BIGINT	PII
anofox_tab_pii_scan_table	Scan table	(table, cols) -> TABLE	PII
anofox_tab_pii_audit_table	Audit table	(table, cols) -> TABLE	PII
anofox_tab_pii_status	List types	() -> TABLE	PII
anofox_tab_pii_detect_emails	Detect emails	(text) -> LIST	PII
anofox_tab_pii_detect_phones	Detect phones	(text) -> LIST	PII
anofox_tab_pii_detect_credit_cards	Detect cards	(text) -> LIST	PII
anofox_tab_pii_detect_ssns	Detect SSNs	(text) -> LIST	PII
anofox_tab_pii_detect_names	Detect names	(text) -> LIST	PII
anofox_tab_pii_detect_ibans	Detect IBANs	(text) -> LIST	PII
anofox_tab_pii_is_valid_ssn	Validate SSN	(text) -> BOOLEAN	PII
anofox_tab_pii_is_valid_iban	Validate IBAN	(text) -> BOOLEAN	PII
anofox_tab_pii_is_valid_credit_card	Validate card	(text) -> BOOLEAN	PII
anofox_tab_pii_is_valid_nino	Validate NINO	(text) -> BOOLEAN	PII
anofox_tab_pii_is_valid_de_tax_id	Validate DE Tax	(text) -> BOOLEAN	PII
anofox_tab_pii_is_valid_crypto_address	Validate crypto	(text) -> BOOLEAN	PII
anofox_tab_pii_mask_column	Type-specific mask	(val, type, strat) -> VARCHAR	PII
anofox_tab_pii_redact_column	Redact column	(val, strat) -> VARCHAR	PII
anofox_tab_metric_volume	Row count	(table, min, max) -> TABLE	Quality
anofox_tab_metric_null_rate	Null percentage	(table, col, max) -> TABLE	Quality
anofox_tab_metric_distinct_count	Cardinality	(table, col, min, max) -> TABLE	Quality
anofox_tab_metric_schema	Schema check	(table, cols[]) -> TABLE	Quality
anofox_tab_metric_freshness	Data recency	(table, col, max_age) -> TABLE	Quality
anofox_tab_metric_zscore	Z-score outliers	(table, col, threshold) -> TABLE	Anomaly
anofox_tab_metric_iqr	IQR outliers	(table, col, mult) -> TABLE	Anomaly
anofox_tab_metric_isolation_forest	Isolation Forest	(table, col, ...) -> TABLE	Anomaly
anofox_tab_metric_isolation_forest_multivariate	Multivariate IF	(table, cols, ...) -> TABLE	Anomaly
anofox_tab_metric_dbscan	DBSCAN	(table, col, eps, min_pts) -> TABLE	Anomaly
anofox_tab_metric_dbscan_multivariate	Multivariate DBSCAN	(table, cols, eps, min_pts) -> TABLE	Anomaly
anofox_tab_outlier_tree	Explainable outliers	(table, cols, mode) -> TABLE	Anomaly
anofox_tab_diff_hashdiff	Hash-based diff	(src, tgt, keys[]) -> TABLE	Operations
anofox_tab_diff_joindiff	Join-based diff	(src, tgt, keys[]) -> TABLE	Operations

Showing 78 of 78

---

Performance Tips

• Fast functions (<1ms): Regex, format, syntax checks, PII pattern matching
• Medium functions (~100ms): DNS, format validation
• Slow functions (~500ms): SMTP, carrier lookup
• ML functions (~10ms/KB): NER-based PII detection (names, orgs)
• Data-dependent (O(n)): Anomaly detection, metrics, table scans
• Parallelizable: All functions work on single columns

---