Not placeholder (N/A, UNKNOWN, etc.)

string_not_placeholder - Column-level - String

Validates that non-null values aren't placeholder text such as N/A or UNKNOWN.

Parameters

Parameter	Type	Default	Required	Description
placeholders	list	none	Yes	List of disallowed values, e.g. N/A, UNKNOWN, or TBD.
case_sensitive	bool	True	No	If false, matching against the placeholder list is case-insensitive.
threshold_percent	float	0.0	No	Fail if the percentage of placeholder values exceeds this.

YAML example

checks:
  - name: example_string_not_placeholder
    check_type: string_not_placeholder
    table_name: schema.table
    column_name: example_column
    parameters:
      placeholders: <placeholders>
      case_sensitive: true
      threshold_percent: 0.0

See YAML check format for the full field reference.