Do we have a configuration in Snowflake target tha...
# plugins-generals
Siddu Hussain
05/21/2024, 3:49 PMDo we have a configuration in Snowflake target that will change load type based on Stream in a tap? I have a tap that needs to overwrite a few streams, append a few, and upsert a few. Do we have a way to handle this scenario?
✅ 1
v
visch
05/21/2024, 4:02 PMs
Siddu Hussain
05/21/2024, 5:00 PMI did try this it FULL_TABLE for overwrite but it was appending it, it gets into upsert when I define Primary Key but not working on Full Overwrite with
replication-method: FULL_TABLESiddu Hussain
05/21/2024, 5:30 PMcorrection it's not upsert too by default its append always even with FULL LOAD or defining replication key
Siddu Hussain
05/21/2024, 5:53 PMok it works with the Primary key set --> upsert
no primary key --> append
➕ 1
👍 2
4 Views