Azure Data Factory scheduled trigger doesn't work properly

Michal Tonia 0 Reputation points
2023-06-01T06:09:02.77+00:00

I have a pipeline in ADF which copies table from one DB to another. Pipeline includes "truncate table" query, to clean the sink table before another data dump. When manually starting the process via "Debug" it runs fine, however using scheduled trigger (daily run) it only truncates the table, leaving empty sink table.

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

3 answers

Sort by: Most helpful
  1. Samy Abdul 3,366 Reputation points
    2023-06-01T11:12:15.9+00:00

  2. ShaikMaheer-MSFT 38,326 Reputation points Microsoft Employee
    2023-06-01T13:18:14.4133333+00:00

    Hi Michal Tonia,

    Thank you for posting query in Microsoft Q&A Platform.

    Truncate statement rows all rows in table. But table will be still present with no rows. So after truncating when you copy data, it should copy rows successfully.

    Please make sure, your truncate statement is in pre-copy field. Which ensures, first truncate table and then only copy data to the table.

    Also, please make sure you publish your changes after debugging or testing. Because triggers will pick only published changes into consideration to run.

    Hope this help. Please let me know if any further queries.


    Please consider hitting Accept Answer button. Accepted answers help community as well.


  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.


    Comments have been turned off. Learn more