Validation

On this page
Constraints

OndatraSQL constraints validate rows before data is written. If any row fails, the model is blocked and nothing is inserted into your DuckLake tables.

Audits

OndatraSQL audits detect dataset-level regressions inside the materialize transaction. A failing audit aborts atomically with no data committed.

Warnings

OndatraSQL warnings surface data quality issues without stopping the data pipeline. Monitor thresholds and track known issues over time.