Does Vertica provide upsert support while loading data?

vmnnn

I am evaluating pushing data to Vertica from one of our client applications. The client application receives database updates and inserts and we need to push this data to Vertica as and when it arrives. From the Vertical technical guide, I saw we can load data using COPY command. Since we receive incremental data over a period of time, I also explored Apache Kafka topic integration that Vertica provides. However, it's not clear how I can update a record that was inserted earlier. Because the documentation says that it uses COPY command internally in the Scheduler that reads messages from Kafka topic. Does Vertical internally handle upsert or is there a way I can tell Vertica to update this record and not insert?

Our client application is a .NET Core application.

SruthiA

You can try using the ADO.NET Connector from vertica. The below documentation page has details pertaining to the scenario you are looking for.
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/ConnectingToVertica/ClientADO/UsingTheVerticaDataAdapter.htm

vmnnn

@SruthiA Thank you for the pointer. I am creating a sample app and verifying it.