Invalid error for string field

[mangeshj]

hi team,
i am getting the below error for simple string column first_name , while reading just loading
csv file to snowflake table .
is this a problem of snaps , as per error below , it is recommending below resolution

Resolution:
Please file a defect against the snap

i have used Mapper snaps with Mapping table expression - $first_name and target path is $first_name .
after executing pipeline , got below error . i am not sure what i am missing here .

is there any access issue to create internal temporary table or missing some expression in column first_name

error :
Error creating or writing input data to the temp table “DET_INTERNAL_POC”.MERGE_TEMP_TABLE_31c9e4ce_4de1_4d24_8b77_e29a9d11a063

Resolution:
Please file a defect against the snap

Reason:
SQL compilation error: error line 1 at position 116
invalid identifier ‘“first_name”’
Hide Details…
Snowflake - Bulk Upsert[55aeb42a050186140d44b424_374b62e2-71de-42b7-bb21-2a541331415b – 1c44770d-9538-4f0b-80c7-8d558fa91a4b]
com.snaplogic.snap.api.SnapDataException: Error creating or writing input data to the temp table “DET_INTERNAL_POC”.MERGE_TEMP_TABLE_31c9e4ce_4de1_4d24_8b77_e29a9d11a063
at com.snaplogic.snaps.snowflake.BulkUpsert.loadTempFileIntoTempTable(BulkUpsert.java:455)
at com.snaplogic.snaps.snowflake.BulkUpsert.handle(BulkUpsert.java:391)
at com.snaplogic.cc.snap.common.SnapRunnableImpl.callback(SnapRunnableImpl.java:840)

[RogerSramkoski]

Hello @mangeshj! In my experience, Snowflake returning an invalid identifier error means I used the wrong quotes - single when I should have used double, or vice versa - or I referenced the field name incorrectly, like first_name instead of firstName. I will provide some examples as soon as I can. Could you share a screenshot of your Snowflake Bulk Upsert configuration for the time being?