Skip to main content

Validate Schema

Run a validation suite against all tables in the specified source schema.

Syntax​

validate schema <source schema reference> using validation suite <suite reference> [with destination schema <destination schema reference>] [with replace]

Parameters​

source schema reference​

String — Name of the schema to validate.

validation suite reference​

String — Name of the validation suite to apply to tables in the source schema, optionally qualified by project.

Options​

destination schema reference​

String — Name of the schema where row-by-row validation result tables will be written.

with replace​

Whether Magpie should overwrite tables in the destination schema, if they already exists. Consider using this option if you are running a validation suite as part of a script.