Skip to content

Column Size Conditions

A Column Size condition matches a column’s declared schema size (for example, the 255 in a VARCHAR(255) definition) rather than the length of the sampled data it actually holds. For a condition based on sampled value length instead, see Data Length Conditions.

  • Comparator — see Classifier Rules: Comparators for the shared numeric comparison options.
  • Size — an integer cutoff, compared against the column’s declared schema size.

Unlike Data Length, Column Size has no trim option and no match-threshold setting: it’s a single deterministic comparison against the column’s schema definition, not a percentage of sampled values.

This condition matches a column whose declared size is at least 50:

{ "target": "COLUMN_SIZE", "comparator": "greater_than_or_equal", "size": 50 }
  • The classification report shows the column’s actual declared size for a Column Size match, with the unit resolved from the column’s data type: text-family types (for example CHAR, VARCHAR, TEXT, STRING, CLOB) display as characters, binary-family types (for example BINARY, BLOB, BYTEA) display as bytes, and any other or unrecognized data type falls back to a generic characters/bytes label.

  • A Column Size match alone always produces a Low Match Confidence badge.

Column Size conditions evaluate on every classification job, with no gating by data source or processing location. See Classification Processing Location for the full picture.