cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Snowflake Bulk Upsert not taking pipeline parameters

mxpeskir
New Contributor

I have a simple, two-snap pipeline: read data from an Azure DB, upsert data to Snowflake.
When I specify all schema and table names, and the key columns in the upsert, everything works. Now I would like to use parameters.

Pipeline Parameters
image

Bulk Upsert Settings
image

Error Message
Invalid key column name is specified.
Resolution: Please enter one or more valid key column names, or check if the table exists.
Reason: A valid column name needs to be specified.

Ok, fine, so Iโ€™ll hardcode the column name.
image

New Error Message
Error creating or writing input data to the temp table โ€œSNOWTESTโ€.MERGE_TEMP_TABLE_8ac3e437_85fb_40e3_be5a_6f6aebd91196
Resolution: Please file a defect against the snap
Reason: SQL compilation error: error line 1 at position 72 invalid identifier โ€˜โ€œCustomNameโ€โ€™

Seems like such a straightforward operation to be receiving these kinds of error messages. Iโ€™ve tried different things with expressions, but nothing makes much of a change. What am I missing here? Iโ€™m very new to SnapLogic so donโ€™t ignore rookie mistakes, but again Iโ€™ve had success with it fully hardcoded. Thanks!

0 REPLIES 0