I created a pipeline using copy data to extract from one database to another database
First both source and sink databases had a pk key of 3 columns, when copying data manually it worked like a charm, but when triggered it would give a pk duplicated error, so what i did was deleting the pk key on the sink side, and now it doesn't give error but it duplicates rows as it doesn't when manually