APPLY_CHANGES_FROM_SNAPSHOT_ERROR error condition

SQLSTATE: 22000

An error occurred during the AUTO CDC FROM SNAPSHOT operation.

ACFS_AUTOCDC_INTEROP_DISABLED

ACFSUnifiedTableProcessor is gated by dlt-pipelines.enableACFSAutoCDCInterop and is not enabled.

ACFS_WITH_EXPECTATION_DISABLED

ACFSUnifiedTableProcessor requires enableACFSWithExpectation to be enabled.

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.

INTEROP_IGNORE_NULL_UNSUPPORTED

Target <target> is written by both an apply_changes_from_snapshot flow and the apply_changes flow <flowName>, which sets ignoreNull=true. Set ignoreNull=false on every apply_changes flow that shares a table with apply_changes_from_snapshot.

INVALID_SNAPSHOT_VERSION

AUTO CDC 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.

MISSING_AUTOCDC_SYSTEM_COLUMNS

Target table is missing required system columns: <missing>. ACFSUnifiedTableProcessor requires a target table with AutoCDC-compatible system columns (__Timestamp, __UpsertVersion, __DeleteVersion). The table may need to be recreated with the correct schema.

NULL_SNAPSHOT_VERSION

None snapshot version found.

OUT_OF_ORDER_SNAPSHOT_VERSION

Snapshot need to be processed in-order: the snapshot version <currentVersion> is not larger than the latest processed version <previousVersion>.

SCD_TYPE_2_NOT_SUPPORTED

ACFSUnifiedTableProcessor only supports SCD Type 1. SCD Type 2 is not supported for unified table writes.

SNAPSHOT_VERSION_NOT_SORTABLE

Snapshot version need to be sortable.

SQL_QUERY_SOURCE_NOT_SUPPORTED

AUTO CDC ... FROM SNAPSHOT with a SQL query snapshot source is not supported.