Is there a way to pass column list argument for column mapping between spark and synapse table from databricks spark for write semantics as copy as we pass it while running copy command from synapse?
Is there a way to pass column list argument for column mapping between spark and synapse table from databricks spark for write semantics as copy as we pass it while running copy command from synapse?
Hello ,
Just wanted to follow up and check if the below suggestion helped you resolve the issue . Also if case if you have a better work around or resolution please do share that with the community as it will help other community members .
Thanks & stay safe
Himanshu
Hello,
Just wanted to check again if the below suggestion helped you resolve the issue . Also if case if you have a better work around or resolution please do share that with the community as it will help other community members .
Thanks
Himanshu
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
29 people are following this question.