Back

Reliability

Auto-skip primary key constraints when using primaryKeysOverride

Tables with primaryKeysOverride configured automatically omit the PRIMARY KEY constraint from destination DDL, and the override now reaches Oracle pipelines.

When a table has primaryKeysOverride configured, Artie now automatically omits the PRIMARY KEY (...) constraint from destination DDL. Previously, this had to be configured manually, and a separate bug prevented primaryKeysOverride from reaching Transfer for Oracle pipelines entirely.

Why this matters

  • Prevents destination table creation failures when overridden keys include nullable columns
  • Fixes Oracle pipelines that rely on unique indexes instead of declared primary key constraints
Primary key override docs