While replicating data from Salesforce to Google Big Query we are frequently having data errors.
Most of the time we are not able to identify the cause of those errors since the logs are not detailed enough (we cannot keep verbose logs always active in production right now) and the errors are not written in attrep_apply_exceptions since it would require the transactional/1:1 mode that is not compatible with Big Query.
We already discussed the thing with Support and SMEs but they
We would have the opportunity to understand what causes those errors in some way, it is not relevant if in the logs or in a table. It is the only way to go to the team managing the source system and work with them to solve the root cause of the errors.