Error: Column Name padb_internal_mddl_key_col Conflicts With an Internal Column Name

Issue

Syncs fail. The following error appears:

ERROR: column name "padb_internal_mddl_key_col" conflicts with an internal column name

Environment

Destination: Redshift

Resolution

To resolve this issue, update the affected table's sort key to a different column that avoids conflicts by running the following query:

ALTER TABLE <SCHEMA>.<TABLE_NAME> ALTER SORTKEY (<NEW_SORT_KEY>);

Cause

This issue occurs when multidimensional data layout (MDDL) sorting is enabled in your destination and the affected table's existing sort key conflicts with an internal Redshift column name.