Value in allowed options

allowed_values - Column-level - Common column checks

Validates that every non-null value in a column is in a fixed set of allowed values.

Parameters

Parameter	Type	Default	Required	Description
allowed_values	list	none	Yes	List of allowed values (strings or numbers).
threshold_percent	float	0.0	No	Fail if the percentage of rows with disallowed values exceeds this.

YAML example

checks:
  - name: example_allowed_values
    check_type: allowed_values
    table_name: schema.table
    column_name: example_column
    parameters:
      allowed_values: <allowed_values>
      threshold_percent: 0.0

See YAML check format for the full field reference.