Skip to main content

Validate Table

Run a validation suite against a table.

Syntax​

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

Parameters​

source table reference​

String — Name of the table to validate, optionally qualified by schema.

validation suite reference​

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

Options​

destination table reference​

String — Name of the table where row-by-row validation results will be written. If left blank, a table name will be generated for you based on the name of the source table and the validation suites.

with replace​

Whether Magpie should overwrite the output destination table, if it already exists. Consider using this option if you are running a validation suite as part of a script.