rules.md

Built-in Rules

Data Quality Rules

Rule	Purpose	Key Parameters
NotNullAndNotNaNValidation	No NULL/NaN in specified columns	columns
WholeTableNotNullAndNotNaNValidation	No NULL/NaN in any column	-
DataTypeValidation	Verify column data types	column_types
ValueSetValidation	Values in allowed set	column, expected_values
RowCountValidation	Row count within bounds	expected_count
ArrayCardinalityValidation	Array length constraints	array_column, expected_length

Referential Integrity

Rule	Purpose	Key Parameters
ReferentialIntegrityValidation	Foreign key validation	fk_column, ref_table, ref_column

PostGIS Rules

Rule	Purpose	Key Parameters
GeometryContainmentValidation	Geometry validity & containment	geom, ref_table, ref_geom, ref_filter, filter_condition
SRIDUniqueNonZero	SRID is unique and non-zero	geom
SRIDSpecificValidation	SRID matches expected value	geom, expected_srid

Rule Registration

Rules are registered with the @register decorator:

@register(
    task="data_quality",
    table="schema.table_name",
    rule_id="MY_RULE",
    # rule-specific params...
)
class MyRule(SqlRule):
    ...