Snowflake connection "The field already exists in the record"

[Pbiuserr]

Hello,

I am trying to do a join on snowflake database when loading data but I got an error that "The field already exists in the record". What does it mean? That there can't be same column/field name in both tables? I want just to obtain LEFT JOIN,. It doesn't look like something extraordinary

select * from "Database"."Schema"."Table" as JOB
JOIN "Database"."Schema"."Table" as CAT

ON JOB.ID=CAT.ID

AND JOB.CODE=CAT.CODE

I have filled server, warehouse, role, database in advanced options of Snowflake connector

Thank you for your help

[amitchandak · Accepted solution]

@Pbiuserr , You can not take the same column name from both tables. So take all fields from one table and selected them from another table, rename the columns in the query if needed

select JOB,*, CAT.ID as cat_ID  from "Database"."Schema"."Table" as JOB
JOIN "Database"."Schema"."Table" as CAT

ON JOB.ID=CAT.ID

AND JOB.CODE=CAT.CODE