Microsoft CDC Client

Hi,

We are using Microsoft SQL CDC Client to extract changes on one of our database. Now we noticed that the target (a Snowflake destination) is complaining about unknown operations.

So added this following step to the data flow:

       if (records[i].attributes['sdc.operation.type'] == 5)
         continue;
 
        sdc.output.write(records[i]);

Is it normal that we have to filter out operation type 5 manually? So that the pipeline works.

Is there an example pipeline (SQL CDC → Snowflake) so that we could apply best practices

Thanks

Sebastian