I use dataflow inside for each loop and there is a condition in dataflow to fail it when this condition achieved, the dataflow already failed , but it also enforce to insert data into target tmp table . my question is there any some how to prevent data f

Karim Rayan 0 Reputation points
2023-10-17T10:41:39.6533333+00:00

Hint : I try to use conditional split but it does not achieve what I need

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,467 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,752 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AnnuKumari-MSFT 31,721 Reputation points Microsoft Employee
    2023-10-19T12:24:06.0133333+00:00

    Hi Karim Rayan ,

    Welcome to Microsoft Q&A platform and thanks for posting your query here.

    As I understand your query, you are trying to avoid inserting data into temp table after dataflow is intentionally failed when it meets a certain condition. Please let me know if that is not the correct understanding of your query.

    Could you please share more insights on what did you exactly try with conditional split transformation to achieve your requirement ? May be screenshots of your dataflow would be helpful.

    As per my knowledge, Conditional Split transformation should help you in this scenario:

    1. Add a Conditional Split transformation to your Data Flow.
    2. Configure the Conditional Split transformation to evaluate the condition that causes the Data Flow to fail. For example, you can use an "If Condition" to check for a specific value in a column.
    3. Add two outputs to the Conditional Split transformation: one for the data that meets the condition, and one for the data that does not meet the condition.
    4. Connect the output for the data that does not meet the condition to the sink transformation where 'Allow insert' is checked(default setting).
    5. Connect the output of data that meet the condition to another sink, but uncheck the 'Allow insert' option for this sink.

    Hopefully, this should help. If it doesn't then kindly help with more details of your dataflow configuration so far. Thankyou