Hi @Michal Tonia , you might be truncating the table and not checking the auto create table option in copy activity.
https://learn.microsoft.com/en-us/answers/questions/773632/data-factory-copy-auto-create-sink-table Thanks
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
Hi @Michal Tonia , you might be truncating the table and not checking the auto create table option in copy activity.
https://learn.microsoft.com/en-us/answers/questions/773632/data-factory-copy-auto-create-sink-table Thanks
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.
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