Data Factory Tutorial - How to add an Pre Copy Script
Learn how to add an Pre-copy script to your pipelines in this Data Factory Tutorial. In this video I show you how to truncate a table using an Pre-copy script within a copy activity. This is useful if you are loading data to a staging table that will then be processed further, we don't want to just keep adding data and a Pre-copy script can be used to truncate the sink or target table.
I also discuss adding permissions for the principal that Data Factory runs under to the database so that it can truncate tables in the database by granting alter permission on the object.
