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.