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.

INTEROP_CONTINUOUS_NOT_SUPPORTED

Target <target> is written by both apply_changes_from_snapshot and apply_changes in a continuous pipeline. This combination is currently supported only for triggered pipelines.

INTEROP_EXPECTATIONS_NOT_SUPPORTED

Target <target> is written by both apply_changes_from_snapshot and apply_changes, but snapshot flow <flowName> defines expectations. Remove the expectations from the snapshot flow before sharing the target.

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.

INTEROP_KEYS_MISMATCH

Target <target> is written by an apply_changes_from_snapshot flow with keys <snapshotKeys> and the apply_changes flow <flowName> with keys <autoCdcKeys>. Use the same keys for every flow that writes this table.

INTEROP_SCD_TYPE_NOT_SUPPORTED

Target <target> is written by both an apply_changes_from_snapshot flow and an apply_changes flow, which is only supported for SCD Type 1. One of the flows uses SCD type '<scdType>'. Use SCD Type 1 for every flow that writes this table.

INTEROP_SEQUENCING_TYPE_MISMATCH

Target <target> is written by an apply_changes_from_snapshot flow with snapshot version type <acfsType> and an apply_changes flow with sequence-by type <autoCdcType>. Use the same type for both.

INTEROP_SYSTEM_COLUMN_CONFLICT

Cannot add an apply_changes flow to target <target> because the existing apply_changes_from_snapshot table contains user columns reserved by apply_changes: <columns>. Rename or remove the conflicting columns before adding apply_changes.

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 AutoCDC-compatible system columns: <missing>. 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.

SCD_TYPE_2_SYSTEM_GENERATED_COLUMNS_NOT_SUPPORTED

SCD Type 2 tables targeted by both AUTO CDC and AUTO CDC FROM SNAPSHOT flows cannot use Delta generated or identity columns with the current configuration. Unsupported columns: <columns>.

SCD_TYPE_2_TRACKED_COLUMNS_NOT_SUPPORTED

SCD Type 2 tables targeted by both AUTO CDC and AUTO CDC FROM SNAPSHOT flows do not support track_history_column_list or track_history_except_column_list. Remove these options to track changes for all columns.

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.

VERSION_QUERY_REQUIRES_QUERY_SOURCE

AUTO CDC ... FROM SNAPSHOT requires a query snapshot source when a VERSION query is specified.