This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 

Selecting set of required fields only to update in Snowflake Bulk Upsert

arvindnsn
Contributor

โ€Ž03-07-2019 08:51 AM

Hello,

I am trying to do a simple Upsert from Stage to ODS table in the Snowflake DB. The Source and target tables are both in the Snowflake DB. I am using the Snowflake Bulk Upsert Snap to do the Merge.

I have a mapper to map the Columns to the Bulk upsert Snap and have specified the Key columns as mentioned in the below screenshots.

If i have 20 columns to Insert and only 5 columns to update, Ho would i do in the below pipeline scenario.

image

image

Thanks
Aravind N

0 Kudos
0 REPLIES 0