Does this column only contain the values it should?
Declare a accepted_values check in the asset's YAML to restrict a column to allowed values. 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: accepted_valuesRun 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 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.