Which rows have a missing value in a required column?
Declare a not_null check in the asset's YAML to flag null values in a column. Bruin runs it on every pipeline run and fails the run if the check does not pass.
Command
bruin runDefined in
YAML
Works with
Bruin CLI + your warehouse
What you get
Built-in checksruns on every runblocking or warning
How it works in code
columns:
- name: id
checks:
- name: not_nullRun bruin run and the pipeline fails before bad data reaches downstream models.
Related use cases
Built-in column checks
Add a unique check to a column
Are there duplicate keys in this table?
Built-in column checksAdd a accepted_values check to a column
Does this column only contain the values it should?
Built-in column checksAdd a positive check to a column
Are there negative or zero values where only positive are valid?
Catch bad data before it ships
Open source. Built-in and custom checks that run on every pipeline run.