Hello Rishabh ,
Thanks for the ask and also using the forum .
As I understand the ask here is understand as to how column name ( with mapping) can be used in the copy command on Synapse .
Below is the command and screenshot whcih should help you out with that .
COPY INTO NameofTheTable( NameOfTheSourceColumn IndexOfTheColumnOnTheSinkSide)
Please do let me know how it goes .
Thanks & stay safe
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members