Hi Team, I was looking at the target-snowflake GitHub documentation for https://github.com/MeltanoLabs/target-snowflake and have two questions. 1. Trying to wrap my head around the

append-only

vs

upsert

method descriptions for

load_method

. They sound the same to me...or maybe I need more coffee.

The method to use when loading data into the destination. append-only will always write all input records whether that records already exists or not.

Vs

upsert will update existing records and insert new records.

Does

append-only

delete matching records and then just re-insert them, vs a traditional upsert? 2. How would (1) interact with

hard_delete

? Wouldn't choosing

overwrite

as the load method already act as a hard_delete? What about the other two options?