I am new to using Panoply (though not databases) and am having some issues using Panoply with Alteryx. I use the postgres driver to write a new table from Alteryx to Panoply, with one field as “id”, which Panoply often automatically picks up as a Primary Key. However, when I go to update this table using the same workflow in Alteryx (having changed the config to Update; insert if new), the driver reports that a Primary Key is required for updating. My colleague told me this was an issue with file uploads, but that is quite different from using a data connection.
Has anyone seen anything like this before?