The following options are available when configuring a Vertica Write Connector:
- Table Name : the name of the Vertica table to be written
- Write Strategy: The strategy to copy data into Vertica. The "Full Load" strategy will replace the entire tables contents each time that the upstream transform has changed. If the upstream data set contains multiple Ascend partitions and not all partitions are expected to change on each update, then the "Incremental By Partition" strategy allows for Ascend to only update / insert / delete the partitions of the Vertica table that have changed in Ascend.
- A SQL Statement for Ascend to execute before writing: here the user has the possibility to execute a pre-processing script before writing to final table.
- A SQL Statement for Ascend to execute after writing: here the user has the possibility to execute a post-processing script after writing to final table.
Updated about 1 month ago