%3CLINGO-SUB%20id%3D%22lingo-sub-1947297%22%20slang%3D%22en-US%22%3EYou%20can%20enable%20data%20consistency%20verification%20in%20copy%20activity%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWhen%20you%20move%20data%20from%20source%20to%20destination%20store%2C%20Azure%20Data%20Factory%20copy%20activity%20provides%20an%20option%20for%20you%20to%20do%20additional%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcopy-activity-data-consistency%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Edata%20consistency%20verification%3C%2FA%3E%20to%20ensure%20the%20data%20is%20not%20only%20successfully%20copied%20from%20source%20to%20destination%20store%2C%20but%20also%20verified%20to%20be%20consistent%20between%20source%20and%20destination%20store.%20Once%20inconsistent%20files%20have%20been%20found%20during%20the%20data%20movement%2C%20you%20can%20either%20abort%20the%20copy%20activity%20or%20continue%20to%20copy%20the%20rest%20by%20enabling%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcopy-activity-fault-tolerance%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Efault%20tolerance%3C%2FA%3E%20setting%20to%20skip%20inconsistent%20files.%20You%20can%20get%20the%20copied%20and%20skipped%20file%20names%20by%20enabling%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fdata-factory%2Fcopy-activity-log%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Esession%20log%3C%2FA%3E%20setting%20in%20copy%20activity.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH4%20id%3D%22toc-hId--482463769%22%20id%3D%22toc-hId--482462903%22%3E%3CSPAN%3EHow%20data%20consistency%20verification%20works%3A%3C%2FSPAN%3E%3C%2FH4%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EWith%20data%20consistency%20verification%20enabled%2C%20when%20copying%20binary%20files%2C%20ADF%20copy%20activity%20will%20verify%20file%20size%2C%20lastModifiedDate%2C%20and%20MD5%20checksum%20for%20each%20binary%20file%20copied%20from%20source%20to%20destination%20store%20to%20ensure%20the%20data%20consistency%20between%20source%20and%20destination%20store.%20When%20copying%20tabular%20data%2C%20copy%20activity%20will%20verify%20the%20row%20count%20after%20job%20completes.%20Be%20aware%20the%20copy%20performance%20will%20be%20affected%20by%20enabling%20this%20option.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH4%20id%3D%22toc-hId-197592524%22%20id%3D%22toc-hId-2005049064%22%20id%3D%22toc-hId-2005049930%22%3EGet%20started%3A%3C%2FH4%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20ADF%20copy%20activity%2C%20you%20can%20choose%20to%20enable%20%22Data%20consistency%20verification%22%20setting%2C%20and%20then%20decide%20if%20you%20want%20to%20abort%20the%20copy%20activity%20job%20%3CSPAN%3Eor%20continue%20to%20copy%20the%20rest%20once%20inconsistent%20files%20found%20as%20below%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22data%20consistency.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237186iABA934D604A202A9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22data%20consistency.png%22%20alt%3D%22data%20consistency.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH4%20id%3D%22toc-hId-197594601%22%20id%3D%22toc-hId-197595467%22%3EGet%20the%20verification%20result%20after%20copy%20job%20completes%3A%3C%2FH4%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22data%20consistency%20output.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F237190i900F8BFE5A5931E3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22data%20consistency%20output.png%22%20alt%3D%22data%20consistency%20output.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1947297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EAzure%20Data%20Factory%20copy%20activity%20provides%20an%20option%20for%20you%20to%20do%20additional%20data%20consistency%20verification%20to%20ensure%20the%20data%20is%20not%20only%20successfully%20copied%20from%20source%20to%20destination%20store%2C%20but%20also%20verified%20to%20be%20consistent%20between%20source%20and%20destination%20store.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1947297%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Factory%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBig%20Data%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECopy%20Activity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

When you move data from source to destination store, Azure Data Factory copy activity provides an option for you to do additional data consistency verification to ensure the data is not only successfully copied from source to destination store, but also verified to be consistent between source and destination store. Once inconsistent files have been found during the data movement, you can either abort the copy activity or continue to copy the rest by enabling fault tolerance setting to skip inconsistent files. You can get the copied and skipped file names by enabling session log setting in copy activity. 

 

How data consistency verification works:

 

With data consistency verification enabled, when copying binary files, ADF copy activity will verify file size, lastModifiedDate, and MD5 checksum for each binary file copied from source to destination store to ensure the data consistency between source and destination store. When copying tabular data, copy activity will verify the row count after job completes. Be aware the copy performance will be affected by enabling this option.

 

Get started:

 

In ADF copy activity, you can choose to enable "Data consistency verification" setting, and then decide if you want to abort the copy activity job or continue to copy the rest once inconsistent files found as below:

data consistency.png

 

Get the verification result after copy job completes:

 

data consistency output.png