can anyone help to explain the difference between sync mode from source and destination? I want to use the incremental sync feature, but not clear if they are supported. For example, airbyte document said MSSQL destination connector does NOT support ‘Incremental’, and the source connector mssql supports ‘Incremental Sync - Append’

Hey @Thao Ton, According to our docs, Source MSSQL and Destination MSSQL both support incremental. Usually if a source supports incremental, the destination also supports it. Let me know if I’m misunderstanding