Sink Errors setting

Shreyash Choudhary 126 Reputation points
2023-02-27T14:26:45.7266667+00:00

User's image

Hi, what if i changed it to continue on error by changing default setting , i just dont want it should fail, can anyone explain continue on error will be the right choice or stop on first error?,also it does work only on azure sql database dataset, coz i have azure synapse analytics, is this setting usefull?

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,356 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,913 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha-msft 19,376 Reputation points Microsoft Employee
    2023-02-28T20:59:22.95+00:00

    Hello @Shreyash Choudhary , Thanks for the question and using MS Q&A platform.

    i just dont want it should fail, can anyone explain continue on error will be the right choice or stop on first error?

    Yes , that's what it will do.
    Read more here : https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-fault-tolerance
    User's image

    also it does work only on azure sql database dataset, coz i have azure synapse analytics, is this setting usefull?

    Yes it does . please refer to the same document above

    Thanks Himanshu

    Please accept as "Yes" if the answer provided is useful , so that you can help others in the community looking for remediation for similar issues.