DC_SCHEMA_CHANGE_ERROR error class

  • Article

SQLSTATE: none assigned

A schema change has occurred in table <tableName> of the <sourceName> source.

COLUMN_RENAME

New columns <newColumns> were added and existing columns <missingColumns> were dropped simultaneously. It's possible that one or more columns were renamed. Please perform a FULL REFRESH on the specific destination table.

COLUMN_TYPE_CHANGE

The data types of columns <columnNames> were changed. Please re-run the entire pipeline or refresh the specific destination table to apply the new data types.

CURSOR_KEY_CHANGE

The cursor key was changed from <oldKey> to <newKey>. Please perform a FULL REFRESH on the specific destination table.

DROP_COLUMNS

Columns <droppedColumns> were dropped. Please re-run the entire pipeline or refresh the specific destination table to update the new schema.

DROP_TABLE

The target table was dropped from the source. It will be removed from the pipeline in the next run but the destination will be retained. To remove the destination table, please manually drop it.

INCOMPATIBLE_COLUMN_TYPE_CHANGE

The data types of at least one of the columns <columnNames> were changed and cannot be processed properly. Please perform a FULL REFRESH on the specific destination table.

NEW_COLUMNS

New columns <newColumns> were added. Please re-run the entire pipeline or refresh the specific destination table to include the new columns.

PRIMARY_KEY_CHANGE

The primary key was changed from <oldKey> to <newKey>. Please perform a FULL REFRESH on the specific destination table.