Lookup Validator

Specification

{
  "validatorType": String,
  "name": String,
  "description": String,
  "fields": FieldSelectorSpec,
  "lookupTableSchema": String,
  "lookupTable": String,
  "lookupColumn": String
}

Structure Values

Field Name

Type

Description

Required

Default

validatorType

String

The type of validator to construct

Required

name

String

The name of the validator. Must be unique within the validation suite.

Required


description

String

Expanded validator information.


None

fields

Object

A Field Selector Spec

Required

lookupTableSchema

String

The name of the schema the lookup table will be in.

None

lookupTable

String

The name of the lookup table to be used in the validator.

Required

lookupColumn

String

The column from the lookup table to be joined with the original table to test the validator with.

Required

Example

{
  "validatorType": "lookup",
  "name": "sample_lookup_validator",
  "description": "I can validate from another table",
  "fields": {
    "fieldSelectorType": "SingleField",
    "fieldName": "col_name"
  },
  "lookupTableSchema": "sample_schema",
  "lookupTable": "sample_table",
  "lookupTable": "sample_column_name"
}



Was this article helpful?
0 out of 0 found this helpful