Do not use staging tables as a source for validation checks

  • Recommendation: When you create a validation check, do not include columns from staging tables as its source.

  • Rationale: Staging tables are intermediate steps in a data transformation. They are not intended to be used to raise discrepancies.

  • Additional information: If you use staging tables, we recommend that you use them to explicitly define the intermediate tables in a separate staging model, as specified in the Guidance for DMW Implementation and Configuration document.

    We don't recommend using staging tables due to the limitations of the feature.