Skip to content

Data Location Conditions

A Data Location condition matches where a column exists in the database hierarchy (its database, schema, or table) rather than anything about the column itself. It doesn’t match the column name; use a Column Name condition for that.

  • Location — a database, schema, and table value. Any field left as * or empty is treated as a wildcard.

This condition matches any column in the HR schema’s CUSTOMERS table, in any database:

{ "target": "COLUMN_LOCATION", "location": { "database": "*", "schema": "HR", "table": "CUSTOMERS" } }

In Match Confidence scoring, a Data Location match is outranked by a Regex or Column Name match, but outranks a Data Length or Column Size match on the same column.

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