<@U04S8PLJWMT> what happens with _ab_cdc_lsn when ...
# ask-ai
c
@kapa.ai what happens with _ab_cdc_lsn when there is a refresh? Is it set to null?
k
The documentation and tutorials describe what
_ab_cdc_lsn
is and show its values during normal CDC operation, but they do not state how
_ab_cdc_lsn
behaves specifically when a Refresh is run. They only explain that: -
_ab_cdc_lsn
(or
_ab_cdc_cursor
) is “the point in the log where the record was retrieved.” [[CDC overview](https://docs.airbyte.com/platform/understanding-airbyte/cdc)] - During the first CDC sync, a snapshot is taken via
SELECT
(effectively a Full Refresh), and subsequent syncs read from the logs based on the stored log position. [[CDC overview](https://docs.airbyte.com/platform/understanding-airbyte/cdc)] There is also separate documentation for Refreshes and
_airbyte_generation_id
, but it does not mention
_ab_cdc_lsn
or how it changes (or is nulled) during a Refresh. [[Refresh FAQ](https://docs.airbyte.com/platform/operator-guides/refreshes#frequently-asked-questions-faq); [Data generations](https://docs.airbyte.com/platform/1.8/operator-guides/refreshes#data-generations)] So, based on the provided sources: - I cannot confirm that
_ab_cdc_lsn
is set to
null
on refresh. - I also cannot confirm any alternative behavior (e.g., reset, continuity, or special handling) tied explicitly to a Refresh. In short, the knowledge sources do not explicitly document what happens to
_ab_cdc_lsn
when a Refresh is executed.