Load behavior types

Stream Pipelines offer these methods for loading data to a table:

• Upsert
• Insert

When loading data with upsert behavior, existing table records are updated only when the pipeline is processing an event with a higher variation number than the existing one. Pipelines deduplicate records based on the object identifier paths (table primary keys), allowing only a single version of record to exist in the table.