Share via

Forcing an error for a Synapse or ADF data flow

pmscorca 1,007 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,925 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,708 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Subashri Vasudevan 11,206 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 32,906 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.