Validate Table

Run a validation suite against a table.


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


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.


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.

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