I have another question related to "Sync Mode" for tables from the source schema. After I synced once or twice manually, when I examined "Sync Mode" options, I found that certain tables have only "Full Refresh" as the option, while certain other tables (from the same source) have "Full Refresh" as well as "Incremental" as the options. Why is the "Incremental" option not available for certain tables?

Hi @Manish Ballav, the source connector defines the available sync modes for stream directly. If a stream does not expose incremental mode, the related API endpoint for this source is not compatible with an incremental load, or that incremental is not yet implemented for this connector.

Thanks alot, @[DEPRECATED] Augustin Lafanechere! Could you please elaborate on "If a stream does not expose incremental mode"? The two screenshots that I attached belong to the same Salesforce connector and yet, different tables from the same source have different sync modes available!

@Manish Ballav did you find out the reason behind this? I have the same issue