Skip to main content

APPLY_CHANGES_FROM_SNAPSHOT_ERROR error condition

SQLSTATE: 22000

An error occurred during the AUTO CDC FROM SNAPSHOT operation.

DUPLICATE_KEY_VIOLATION

Found <count> rows for key '<key>' in <provenance> table for flow '<flowName>'. Expected at most 1 row per key.

DYNAMIC_SNAPSHOT_VERSION

Snapshot version should be independently evaluable from the table.

FIRST_SNAPSHOT_EMPTY

AUTO CDC FROM SNAPSHOT get None returned from the lambda function as the first snapshot source to be processed. Please make sure at least one valid snapshot source available for processing.

INVALID_SNAPSHOT_VERSION

APPLY CHANGE query requires specification of both snapshot and its version. If no snapshot version is expected, please put null as the place-holder as the second value of the returned tuple.

INVALID_SNAPSHOT_VERSION_TYPE

Snapshot version type is not supported.

INVALID_TUPLE_NULL_SNAPSHOT_VERSION

Invalid snapshot version found for AUTO CDC FROM SNAPSHOT query to target table '<target>'. Snapshot version returned was None but AUTO CDC FROM SNAPSHOT requires a valid non-null snapshot version for each snapshot DataFrame.

MULTIPLE_QUERIES_FOR_TABLE

'<tableName>' already contains a AUTO CDC FROM SNAPSHOT query '<flowName>'. Currently, this API only supports one flow per destination.

NULL_SNAPSHOT_VERSION

None snapshot version found.

SNAPSHOT_VERSION_NOT_SORTABLE

Snapshot version need to be sortable.