Validation

On this page

Three validation stages with distinct fail-modes.

  • Constraints — row-level checks evaluated before write; failure blocks the model
  • Audits — dataset-level checks inside the materialize transaction; failure aborts atomically
  • Warnings — non-blocking observations recorded in metadata
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.