GUI bulk upsert into nullable unique field gives error - duplicate key value violates unique constraint

  • 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?

Write data to SQL databases