Forum Discussion
Cannot see destination table structure in Copy Data activity : Mapping sink is empty
Hello,
I am creating a Pipeline and using a Copy Data activity in it. The source and sink for the Copy Data are two Lakehouses in separate workspaces. I have selected the source and the destination tables but cannot see the destination table structure while mapping the fields manually:
Based on below Community discussion, I even renamed the columns in destination table to match with source but the issue persists. Further, Import Schema option does not either does not return any result or creates a new table in the destination.
Solved: Error - Mapping Sink is Empty. - Microsoft Fabric Community
Can someone please help me in solving this?
Thanks a lot!
Amogh
3 Replies
Hi amoghshahane ,
Please check the table and column names to make sure that the table and column names in the destination table match exactly those in the source table. Even small differences can cause mapping problems.
Also, you can refer to below document:
How to copy data using copy activity - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous ,
Thank you for the suggestion!
I have tried using the same table name and column names but it still does not work. Just to mention, I have multiple columns in my source while I'm using only 2 of those in my destination. Can the number of fields be the problem?
Appreciate your support!
Thanks,
Amogh
Update:
I did not find a solution to this but a workaround: I followed below article and through 'Add dynamic content' option, I could replicate full table from source to destination - my original requirement was to just replicate few columns and not entire table:
Also, the option insert as overwrite had to be selected for this to work.
Please let me know if someone finds a better solution.
Cheers,
Amogh
