-
Goal: Hi, I'm trying to bulk upsert external data with the GUI mode in the database resource query interface in the workflow.
-
Issue: A field that's set to both unique and nullable triggered this error "duplicate key value violates unique constraint" because there're many null values.
-
Question: I need to keep those settings for unique constraint and nullable, is there any way to update the database through the UI or SQL?
Hey @evelyn_p,
Apologies for the delay here! Did you already sort this out? As a workaround, does it work if you use a loop block with individual upserts?
Happy to take a look in office hours