• cannot upsert on Synapse SQL pool with primary key constrains

cannot upsert on Synapse SQL pool with primary key constrains

  • 16Views
  • Last Post 2 weeks ago
0
votes
Ben Townsend posted this 2 weeks ago

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
    (
        [upsertId] ASC
     NOT ENFORCED ,
    CONSTRAINT [PK_P_u_upsertId] UNIQUE NONCLUSTERED
    (
        [upsertId] ASC
     NOT ENFORCED

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.

Thank you!

import upsert synapse primary-key dedicated-sql-pool
0
votes
Mariia Zaharova posted this 2 weeks ago

Hello Ben,

 

We are processing your request and will answer you by email as soon as possible.

 

Best regards,

Mariia

New Ticket
Categories
Popular Tags
Close