Validate your pipeline to ensure it runs successfully without any issues. The output will not be generated if the pipeline fails to execute. The errors can be present in either the individual transformation steps or the Quality pipeline.
Quality validation overview
As you add, remove, or edit steps in a pipeline, Data Quality validates changes to the pipeline and checks for errors. A validation issue is represented on a step by a warning symbol , an error symbol , or a data error symbol . An error prevents execution of a pipeline. A warning does not prevent execution of a pipeline, but it may create unpredictable or unexpected outcomes.
Example:
- The Rename Column step renames a column from "Bank" to "FinancialInstitution".
- The Search and Replace step searches and replaces content in the renamed "FinancialInstitution" column.
- The Case Field step changes field content to title case in the renamed "FinancialInstitution" column and in a "City" column.
An error shows for the Search and Replace step because there will no longer be a "FinancialInstitution" renamed column.
A warning shows for the Case Field step because although there is no longer a "FinancialInstitution" column the step will still be able to change case in the unaffected "City" column. If the Case Field step acted only on the deleted "FinancialInstitution" column, then it too would show an error instead of the warning.
- Resolve the error by reconfiguring the Search and Replace step to search the previously renamed "Bank" column.
- Resolve the warning by removing the reference to the "FinancialInstitution" column or by reconfiguring the Case Field step to change case in the previously renamed "Bank" column.
What causes data errors
Issues such as verification failures, invalid types or formats, or inability to parse data can cause data errors. A data error symbol displays on any step that generates a data error. When you click a step with a data error, red bars mark the columns and rows in the table that contain the errors. Fields that contain errors are highlighted. To view the cause of a data error, you can hover the pointer over a highlighted cell. Use error and warning symbols on steps in a pipeline to guide you through changes necessary to create an error-free pipeline.
Changes you make may create new errors or warnings in subsequent steps. When that happens, proceed iteratively through successive edits and validations to eliminate all errors and warnings from a pipeline. You may choose to add additional transformation steps to fix data errors.