Vertica Bulk Loader
The Vertica Bulk Loader uses VerticaCopyStream to stream to a Vertica database. This is typically significantly faster than loading data through e.g. a Table Output transform. |
Options
Global transform options
| Option | Description |
|---|---|
Transform name | Name of the transform. |
Connection | Name of the database connection on which the target table resides. |
Target schema | The name of the Schema for the table to write data to. This is important for data sources that allow for table names with dots '.' in it. |
Target table | Name of the target table. |
Truncate table | Truncate this table before loading data |
Truncate on first row | Only truncate this table if there is data (when the first row is received) |
Specify database fields | Enable this option to specify the fields in the Database fields tab. Otherwise all fields are taken into account by default. |
Main options tab
| Option | Description |
|---|---|
Insert directly to ROS | Insert directly to ROS (Read Optimized Store). A ROS (Read Optimized Store) container is a set of rows stored in a particular group of files |
Abort on error | Stop or continue loading data as soon as an error occurs |
Exceptions log file | Path to the exceptions log file |
Reject data log file | Path to the rejected data log file |
Stream name | Name for the Vertica COPY stream |