Forcing an error for a Synapse or ADF data flow

pmscorca 792 Reputation points
2023-03-23T10:38:10.95+00:00

Hi,

I need to know if it is possible to force or raise an error inside a Synapse or ADF data flow, e.g. for a particular condition of a conditional split.

Thanks

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,358 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,517 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Suba Balaji 11,186 Reputation points
    2023-03-23T14:41:10.3033333+00:00

    Hello @pmscorca

    Using a conditional split doesn't help, but i believe having an Assert Transformation could do the thing for you.

    Have a look at this video, and let us know if that is of help!

    https://www.youtube.com/watch?v=VFRx0wjlA4s

  2. AnnuKumari-MSFT 30,601 Reputation points Microsoft Employee
    2023-03-27T05:45:32.9566667+00:00

    @pmscorca ,

    I understand your requirement is to fail the dataflow on a certain condition.

    You can also explore using SQL connector in the sink and in pre copy script , use RAISERROR function in the query.

    Please accept the answer if it helped. Thanks

    0 comments