Hello Evgeniy ,
In order to insert new records as well as update the existing records onto the target Snowflake table, set "UpdateMode" to 'Update Else Insert'-
does this method support PushDownOptimization?
Here are the listed opertaion supported in PDO
You can instead use the update and upsert operations in the Target transformation to write to Snowflake.