Are you struggling with multi region/multi brand scenario in your Adobe Experience Platform implementation using multiple sandboxes? Does the ensuing cost, governance, and maintenance overhead impact your total effort and timeline?  Adobe has good news for you! 

Please check again the document I cited earlierProfile export behavior | Adobe Experience PlatformTo further de-bug the issue, support ticket is advised

Ok, so your destination is a batch (and not streaming destination). Since I do not have more information on how you have setup the SFTP destination, you can refer this document on what to expect as per how you have scheduled and whether it is full/incremental.Profile export behavior | Adobe Experien...

Please click on the dataflow run hyperlink.The details page also displays a list of identities that failed and identities that were excluded. Information for both the failed and excluded identities is displayed, including the error code, identity count, and description. By default, the list displays...