Are there negative or zero values where only positive are valid?
Declare a positive check in the asset's YAML to require positive numbers. 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: positiveRun bruin run and the pipeline fails before bad data reaches downstream models.
Related use cases
Built-in column checks
Add a not_null check to a column
Which rows have a missing value in a required column?
Built-in column checksAdd 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?
Catch bad data before it ships
Open source. Built-in and custom checks that run on every pipeline run.