Overwrite tables alone failing on a daily basis when triggered

Nanda Kumar Mohan 1 Reputation point

My pipeline is having many tables, out of which 2 tables are overwrite tables and either of the 1 table fails for sure on a daily basis stating insufficient information to connect to source error, but if i use rerun from failed state or if rerun the entire pipeline again it succeeds, not sure what is the problem, i tried retry option but that never worked in my scenario, can someone provide a solution for this, or tell me like how can automate rerun from failed state activity in ADF.

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
{count} votes