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.