Translators

DQX YAML

Translates JSON Schema constraints to DQX YAML quality checks (.yaml). The translator requires databricks-labs-dqx==0.8.0.

Example

Input (JSON Schema):

{
  "type": "object",
  "required": ["id", "status"],
  "properties": {
    "id": { "type": "string", "format": "uuid" },
    "status": { "type": "string", "enum": ["active", "inactive"] },
    "age": { "type": "integer", "minimum": 0, "maximum": 150 }
  }
}

Output (DQX YAML):

- criticality: error
  check:
    function: is_not_null
    arguments:
      column: id
- criticality: error
  check:
    function: regex_match
    arguments:
      column: id
      regex: ^[0-9a-fA-F]{8}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{4}-[0-9a-fA-F]{12}$
- criticality: error
  check:
    function: is_not_null
    arguments:
      column: status
- criticality: error
  check:
    function: is_in_list
    arguments:
      allowed:
        - active
        - inactive
      column: status
- criticality: error
  check:
    function: sql_expression
    arguments:
      expression: "`age` IS NULL OR (`age` >= 0 AND `age` <= 150)"
      msg: age must be between 0 and 150