Cannot see destination table structure in Copy Data activity : Mapping sink is empty

[amoghshahane]

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

[amoghshahane]

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:

Copy Data from Lakehouse in Another Workspace Using Data pipeline | Microsoft Fabric Blog | Microsof...

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

[amoghshahane]

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

[Anonymous]

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 Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.