Hi Aleksi, I really need your help, I am using Fabric Data Pipeline to copy data from one warehouse to another. But the copied data gets appended. But I need to overite the data. Couldnt find that option, is there a workaround for this ?
When doing a copy to a data warehouse you have to define a pre-copy script if you want to do "an overwrite" to that table. Basically you need to truncate the table before loading the data. Pre-copy script can be found under advanced settings in the destination tab of the copy data. Script goes like this: TRUNCATE TABLE *schema*.*table*; For example: TRUNCATE TABLE dbo.table1; Hope this helps! :)
Your videos are so helpful and just when I need them. Thank you!!!
I am very glad that my videos are helpful to you! :)
Hi Aleksi, I really need your help, I am using Fabric Data Pipeline to copy data from one warehouse to another. But the copied data gets appended. But I need to overite the data. Couldnt find that option, is there a workaround for this ?
When doing a copy to a data warehouse you have to define a pre-copy script if you want to do "an overwrite" to that table. Basically you need to truncate the table before loading the data. Pre-copy script can be found under advanced settings in the destination tab of the copy data.
Script goes like this:
TRUNCATE TABLE *schema*.*table*;
For example:
TRUNCATE TABLE dbo.table1;
Hope this helps! :)