Share via

Azure Data Factory scheduled trigger doesn't work properly

Michal Tonia 0 Reputation points
Jun 1, 2023, 6:09 AM

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.
11,170 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Samy Abdul 3,376 Reputation points
    Jun 1, 2023, 11:12 AM

  2. ShaikMaheer-MSFT 38,501 Reputation points Microsoft Employee
    Jun 1, 2023, 1:18 PM

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.