Summary
Explanation of the purpose of the _ab_cdc_event_serial_no field in MSSQL CDC replication to Snowflake warehouse.
Question
For MSSQL CDC replication onto target Snowflake warehouse, I could notice a field “_ab_cdc_event_serial_no” in the scd table. What is the purpose of the field? http://kapa.ai|kapa.ai could not get any answer from documentation base.
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
["mssql-cdc", "snowflake-warehouse", "_ab_cdc_event_serial_no", "replication"]
<@U05JENRCF7C> Thank you for your response. I understand that during the initial sync, the _ab_cdc_event_serial_no field is null for all rows because the intial load happens from snapshot, that is select statement. However, after performing a bulk update on different rows and making multiple column updates on a single row, the field _ab_cdc_event_serial_no only shows the value “2” for all cases.
I’m struggling to grasp how this mechanism works.