I'm taking a stab at targets and throwing my hat into the ring with a

target-salesforce

🤠 I'm debating how to handle update/insert/upsert/delete/hard deletes. Each type is a different API call with

simple-salesforce

• Does it make sense to have the streams segmented by type? ◦ Example

Account-delete

,

Account

(default to update),

Account-upsert

.... • Or do I keep all the records in the

Account

stream and allow for an optional

_type

field to dictate the behavior? This seems cleaner. ◦ This is easy if I write each record individually, but not sure about sub-segmenting a batch sink. Any ideas? Is there a target that has already addressed something similar?