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.