Hello, newbie here.
My question is possibly to do with primary key but i am not sure:
I uploaded a CSV with 100,000 users - works fast and very happy - search and filter works great
I now wish to enrich them as I got more info about 50,000 of the users, but i can’t seem to find a way to do an Update. so it would add duplicated records, is there a way when importing to ask it to update records if USERNAME field (for example) already exists? if the answer is not - is there another way to do what i want to achieve?
<@990927987765563392> That’s not possible from UI. You will have to write a script & use SDK / API to update records selectively.
I see. are there any ready-made scripts or tools for that?
I am on postgres - perhaps PGAdmin can do that?
Have not tried to upload csv anytime