I'm exploring Skyvia features due to a necessity i have. I need to extract and load data from crm (Hubspot) to a postgres table.
I'm considering using skyvia's data flow (even though it's not included on my current plan) to do this job, but i can't set the upsert operation. I read the Skyvia documentation but it didn't help me to solve where i can set properly this.
PS: The "primary key" i'm using on postgres is the Hubspot Company ID (it has not the pk constraint btw), and i expect Skyvia to insert records that doesn't match any of the existing company ids on the table and update the columns of records that matches company id with the existing ones in the table.
Could you please help me with it?
Also, if i succeed on this task, could i have a test time to see if the functionality satisfy my need properly?