Vertica Snap Pack
Overview
Vertica is a big data analytical database. Use Snaps in this Snap Pack to:
- Lookup and select records.
- Insert, update, and merge records.
- Perform bulk loads and updates.
This Snap Pack contains the following Snaps:
- Vertica - Bulk Load: Loads data from the input stream into a Vertica table using the COPY command for efficient bulk inserts.
- Vertica - Bulk Upsert: Inserts new records or updates existing records in a Vertica table based on key columns, using the COPY command for efficient bulk operations.
- Vertica - Delete: Deletes records from a Vertica table based on a specified WHERE clause condition.
- Vertica - Execute: Executes SQL statements (such as SELECT, INSERT, UPDATE, DELETE, CREATE, DROP) in a Vertica database.
- Vertica - Insert: Executes a SQL INSERT statement to insert records into the selected table of a Vertica database.
- Vertica - Lookup: Looks up records in the target table and returns a selected set of fields for every matched record.
- Vertica - Multi Execute: Executes multiple SQL statements for each input document, with each set of statements run as a single transaction.
- Vertica - Select: Fetches data from a Vertica database by providing a table name and configuring the connection.
- Vertica - Table List: Outputs a list of tables in a Vertica database in topological order based on foreign key dependencies.
- Vertica - Update: Executes a SQL UPDATE statement to update records in a Vertica table.
Supported Version
This Snap Pack is tested against Vertica Analytic Database version 10.0.0-0.