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?

3 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.

Five Stars

Re: Snowflake upsert issue

I created a Hashkey from the unique column index. Like  (OrderNumber + OrderDate + PO_NUmber). I then insert this as my Key Column, it is only used for Upserts, not for referential integrity.

 

I also wrote a Hashing Routine Using either a SHA-1 Hash or a SHA256 to prevent collisions. I am still in testing but it seems to be working.

 

Good luck.