It would be great if fivetran can support insert only operation on destination tables.

CDC increase billing cost on big fat tables in destination.

Different query engines have different query plans, so cost will increase.

with Insert only operation, no need to do any lookups to update/merge the data, just insert the changes from source into destination tables.

as fivetran adds default columns along with one extra columns would suffice to identify when the change took place at source