Four Stars

Snowflake upsert issue

Looks like snowflake upsert is not supported on multiple columns and currently it allows only one column. Is there any alternate?

2 REPLIES
Moderator

Re: Snowflake upsert issue

Hello,

The Upsert operation allows you to merge data in a Snowflake table based on the data that is incoming to tSnowflakeOutput. After selecting Upsert, select the column to be used as the join key of this operation.

Best regards

Sabrina

 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: Snowflake upsert issue

Thank you.   It does not support multiple keys (multiple columns) to join.  It just allows to pick only one key, how do I multi select the join columns.