Skip to content

Valid binary format (magic number)

binary_format - Column-level - Binary

Validates that binary values start with an expected magic-byte signature, e.g. a file format header.

Parameters

Parameter Type Default Required Description
magic_hex str none Yes Expected hex string the value must start with, e.g. 89504E47 for PNG. Must have even length.
threshold_percent float 0.0 No Fail if the percentage of violations exceeds this.

YAML example

checks:
  - name: example_binary_format
    check_type: binary_format
    table_name: schema.table
    column_name: example_column
    parameters:
      magic_hex: <magic_hex>
      threshold_percent: 0.0

See YAML check format for the full field reference.