Snap type: | Write | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap executes a SQL INSERT statement to insert records into the selected table of a Vertica database. The Snap uses the document's keys as columns and document's values as values to insert records. | |||||||||||||
Prerequisites: | N/A | |||||||||||||
Support and limitations: | Works in Ultra Task Pipelines if batching is disabled. | |||||||||||||
Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring Vertica Accounts for information on setting up this type of account. | |||||||||||||
Views: |
| |||||||||||||
Settings | ||||||||||||||
Label* | Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your pipeline. | |||||||||||||
Schema name* | Specify the database schema name. Selecting a schema filters the Table name list to show only those tables within the selected schema. The property is suggestible and retrieves available database schemas during suggest values.
Example: public | |||||||||||||
Table name* | Specify the table on which to execute the insert operation.
Example: emp | |||||||||||||
Create table if not present |
Redshift - Bulk Load | Redshift - Bulk Load | nopanel | true | In the absence of a second input view (the schema/metadata document), the Snap creates a table based on the data types of the columns generated from the first row of the input document (first input view). Default value: Not selected | |||||||||
Preserve case sensitivity |
| |||||||||||||
Number of retries | Specify the maximum number of times that the process must be retried before displaying an error. Default value: 0 | |||||||||||||
Retry interval (seconds) | The maximum resting time in seconds between subsequent retries. Default value: 1 | |||||||||||||
|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|