Insert alias column name from snowflake into azure sql using azure data factory

i have below select query which select values from multiple tables in snowflake and insert into the azure sql
i am using azure data factory for that…

select a.first_name as Name,  b.emp_id as Id from table1 a join table2 b on a.id=b.empId

there is already column created in azure sql for Name and Id
but pipeline failes with below message

Failure happend on sink side
Column NAME cannot found in the Physical data base. 

i am able to create the mapping for the ‘Name’, but even after only Name value getting inserted into the sql table. in this case pipeline succeed but not inserting other column value ‘Id’.
in fact i am not able to add the mapping for other column ‘Id’

Any resolution to this?