On this Page
| Table of Contents | ||||
|---|---|---|---|---|
|
Overview
Snap type: | Write | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap executes a SQL INSERT statement.
| |||||||||||||
| Prerequisites: | [None]
| |||||||||||||
| Known Issues | The Snap might fail due to a connection issue. We recommend that you roll back to the main8614 version. | |||||||||||||
| Support and limitations: | Works in Ultra Pipelines. | |||||||||||||
| Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring JDBC Accounts for information on setting up this type of account. | |||||||||||||
| Views: |
| |||||||||||||
Settings | ||||||||||||||
Label
| Required. 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
| The database schema name. In case it is not defined, then the suggestion for the Table Name will retrieve all table names of all schemas. The property is suggestible and will retrieve available database schemas during suggest values.
Example: SYS
| |||||||||||||
Table name | Required. The table into which to insert the data.
Example: people | |||||||||||||
| Create table if not present | Generates the table statement based on the schema available on the input view. Default value: False | |||||||||||||
| Preserve Case sensitivity | Enables you to specify whether the letter case used in column labels must be preserved while performing the insert operation. Select this option to ensure that the precise cases used are retained. Default value: Not Selected. | |||||||||||||
| Number of retries | Specifies the maximum number of attempts to be made to receive a response. The request is terminated if the attempts do not result in a response. Example: 3 Default value: 0
| |||||||||||||
| Retry interval (seconds) | Specifies the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. Example: 10 Default value: 1 | |||||||||||||
|
| |||||||||||||
| Note |
|---|
| This operation is not supported for Apache Hive databases. |
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|