Azure Data Factory pipeline failing on sink side: Job failed due to reason: at Sink 'sink1': Invalid object name '[Table_Name]'.

Thomaz Suzuki 5 Reputation points
2023-10-16T18:13:50.4333333+00:00

I have the following workflow:User's image

It fails on the sink step with: Job failed due to reason: at Sink 'sink1': Invalid object name '[table_name]'.

The thing is that this table_name that shows up in the warning, I'm not using it nowhere in the whole data workflow.

I even tried deleting the dataset and creating again, but no luck.

I'm able to preview the dataset (table the should be updated by the sink step).

Any clues on what is happening?

Thank you on advance.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,755 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Suba Balaji 11,191 Reputation points
    2023-10-17T04:49:59.1966667+00:00

    Hi Thomaz Suzuki

    This error might be due to value being passed to the table field in data set during run time. Can you please tell us if you decide the name of the table dynamically or it is static?

    Also please share us the data set configuration being used in sink.

    This would help us isolate the issue,

    Thanks

    0 comments No comments