If you do not want to retrieve changes using the recovery state table when a CDC job encounters a failure, you can disable recovery in the target and mapping task.
To disable recovery, perform the following tasks:
Set the
disableSnowflakeRecoveryCDC=true
property in the
Additional Write Runtime Parameters
field in the Snowflake Data Cloud Target transformation.
In the
Advanced Session Properties
on the
Runtime Options
tab in the mapping task, remove the configured recovery strategy.
Ensure that the source is not Snowflake in a CDC mapping. If the mapping contains a Snowflake source and target, and if you set the
disableSnowflakeRecoveryCDC
property for the target, the mapping job shows incorrect results.