I am trying to upsert on a table that has primary key constraints created so that there is PK functionality on a Azure Synapse dedicated SQL pool.
Here is the error from Skyvia
The target object 'skyvia.ImportTarget' must have primary key columns for the Upsert operation.
And here is the PK constrain definition from my DDL.
[upsertId] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK_P_upsertId] PRIMARY KEY NONCLUSTERED
NOT ENFORCED ,
CONSTRAINT [PK_P_u_upsertId] UNIQUE NONCLUSTERED
What can I do to get upsert functionality here? It seems that Skyvia does not recognize PK constraints as actual primary keys.
Any insight is appreciated.