On this Page
...
Snap type: | Write | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Description: | This Snap executes a Snowflake SQL Insert statement with given values. Document keys will be used as the columns to insert into, and their values will be the values inserted. Missing columns from the document will have null values inserted into them.
| |||||||||||||
Prerequisites: |
Security Prerequisites: You should have the following permissions in your Snowflake account to execute this Snap:
The following commands enable minimum privileges in the Snowflake Console:
| |||||||||||||
Internal SQL Commands | This Snap uses the INSERT command internally. It enables updating a table by inserting one or more rows into the table.
| |||||||||||||
Support and limitations: |
| |||||||||||||
Known Issues: | Because of performance issues, all Snowflake Snaps now ignore the Cancel queued queries when pipeline is stopped or if it fails option for Manage Queued Queries, even when selected. Snaps behave as though the default Continue to execute queued queries when the Pipeline is stopped or if it fails option were selected. We plan to address this issue in a patch for the next monthly release in December. | |||||||||||||
Account: | This Snap uses account references created on the Accounts page of SnapLogic Manager to handle access to this endpoint. See Configuring Snowflake 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. 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.
Default value: [None] | |||||||||||||
Table name* | Specify the name of the table to execute insert-on.
Default value: [None] | |||||||||||||
Create table if not present |
Default value: Not selected | |||||||||||||
Preserve case sensitivity |
| |||||||||||||
Number of retries | Specify 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. Default value: 0
| |||||||||||||
Retry interval (seconds) | Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. Default value: 1 | |||||||||||||
Manage Queued Queries | Select this property to decide whether the Snap should continue or cancel the execution of the queued Snowflake Execute SQL queries when you stop the pipeline.
Default value: Continue to execute queued queries when the pipeline is stopped or if it fails | |||||||||||||
|
|
...