Skip to main content

APPLY_CHANGES_FROM_SNAPSHOT_ERROR error condition

SQLSTATE: 22000

An error occurred during the APPLY CHANGES 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

APPLY CHANGES 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 APPLY CHANGES FROM SNAPSHOT query to target table '<target>'. Snapshot version returned was None but APPLY CHANGE FROM SNAPSHOT requires a valid non-null snapshot version for each snapshot DataFrame.

MULTIPLE_QUERIES_FOR_TABLE

'<tableName>' already contains a APPLY CHANGE INTO 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.