Forum Discussion

arvindnsn's avatar
arvindnsn
Contributor
7 years ago

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

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.

Thanks
Aravind N

No RepliesBe the first to reply