How to enforce specific column values using config_rules_validator.py?

[toughdave]

Hmm... since I am using the config_rules_validator.py script for data quality checks. How do I ensure that the department_code column only accepts specific strings, like "ENG" or "SCI"?

How should I structure the JSON rules configuration to enforce this?

[toughdave]

Hmm... since I am using the config_rules_validator.py script for data quality checks. How do I ensure that the department_code column only accepts specific strings, like "ENG" or "SCI"?

How should I structure the JSON rules configuration to enforce this?

Oh... got it! I can achieve this by using the allowed_values rule type in your JSON configuration file.

An example structure is:

{
  "rules": [
    {
      "name": "valid_department_code",
      "type": "allowed_values",
      "column": "department_code",
      "values": ["ENG", "SCI"],
      "case_sensitive": true
    }
  ]
}