Microsoft SQL Server Initial Load Doesn'r Work For CDC

[rfre85]

Airbyte version: 1.6.2
Connector Version: 4.1.27

Hi all, we are trying to initial load a MSQL Server database in Snowflake, but getting snapshot error whenever we start sync:

source ERROR debezium-sqlserverconnector-TransPortData4BI-change-event-source-coordinator i.d.r.RelationalSnapshotChangeEventSource(doExecute):193 Error during snapshot java.util.concurrent.ExecutionException: java.lang.InterruptedException: Interrupted while snapshotting table TransPortData4BI.dbo.BasicFeatureSettingEFModel at java.base/java.util.concurrent.FutureTask.report(FutureTask.java:122) ~[?:?]

Can you help us with that? The initial sync works fine when we use full refresh with cursor connection method, only doesn't work when we use CDC.

Thanks.

Rafael