On this Page
Table of Contents | ||||
---|---|---|---|---|
|
Overview
Snap type: | Write | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap executes a SQL INSERT statement. This Snap also supports DML operations operation (CREATE, ALTER, INSERT, and SELECT) when using AWS Athena database.
| |||||||||||||
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 pipelinePipeline. | |||||||||||||
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.
| |||||||||||||
Table name | Required. The table into which to insert the data.
| |||||||||||||
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 Specify the maximum number of attempts to be made to receive a response.retry attempts that the Snap must make in case there is a network failure, and the Snap is unable to read the target file. The request is terminated if the attempts do not result in a response. Example: 3If the value is larger than 0, the Snap first downloads the target file into a temporary local file. If any error occurs during the download, the Snap waits for the time specified in the Retry interval and attempts to download the file again from the beginning. When the download is successful, the Snap streams the data from the temporary file to the downstream Pipeline. All temporary local files are deleted when they are no longer needed. | |||||||||||||
name | retries | page | File ReaderDefault value: 0||||||||||||
Multiexcerpt include macro | ||||||||||||||
Retry interval (seconds) | Specifies the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. Default value: 1Default value: 1 | |||||||||||||
|
|
Note |
---|
This operation is not supported for Apache Hive databases. |
Insert excerpt | ||||||
---|---|---|---|---|---|---|
|