Data Validation

You have the ability to choose whether to check Mandatory and Validate Data options in the Schema > Advanced settings of your data syncs. These options will determine what happens to invalid data in your syncs.

• If both Mandatory and Validated are checked on a column, then rows where the column is empty are rejected

• If just Mandatory is checked on a column, then all rows are synced with the execution log status of failed, and the source error of "Mandatory Rule Violation"

• If just Validated is checked on a column, then all rows are synced.