Azure Data Factory -Mapping DataFlows Error Handling options RRS feed

  • Question

  • Does Dataflow have any error handling mechanism like the copy activity for capturing and separating rows with incompatible data types,column mismatch, Primary keys violation?

    Manish Pradhan

    Thursday, December 5, 2019 12:48 PM

All replies

  • Hello Manish , 

    The schema drift feature can help you here , but then its not a part of any error handling . The PK violations will make the pipeline to fail . 

    Thanks Himanshu

    Thursday, December 5, 2019 6:24 PM
  • Also, if you'd like to write rows that don't conform to a data type, then use a Conditional Split that checks for a NULL return from a casting expression. Here is an example: https://www.youtube.com/watch?v=sPpcSiKQz34 

    • Edited by Mark Kromer Thursday, December 5, 2019 6:40 PM
    Thursday, December 5, 2019 6:40 PM