AlloyDB Execute
In this article
Overview
You can use this Snap to execute arbitrary SQL.
This Snap works only with single queries.
Snap Type
The AlloyDB Execute Snap is a Write-type Snap that executes the specific query.
Prerequisites
A valid account with the required permissions.
Support for Ultra Pipelines Â
Works in Ultra Task Pipelines.
Limitations
Does not support $$
as an escape character for enclosing string input, as $
is a reserved character for variable substitution in SnapLogic..
Known Issues
None.
Behavior Change
Â
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| If the input view is defined, then the WHERE clause can substitute incoming values for a given expression. Valid JSON paths that are defined in the WHERE clause for queries or statements are substituted with values from an incoming document. If the document is missing a value to be substituted into the query or statement documents, it is written to the error view. |
Output | Document  |
|
| The executed query result. If a SELECT query is executed, the query's results are merged into the incoming document and any existing keys will have their values overwritten. On the other hand, the original document is written if there are no results from the query. |
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter while running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines. |
Snap Settings
Asterisk ( * ): Indicates a mandatory field.
Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.
Expression icon ( ): Indicates the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon ( ): Indicates that you can add fields in the fieldset.
Remove icon ( ): Indicates that you can remove fields from the fieldset.
Upload icon ( ): Indicates that you can upload files.
Field Name | Field Type | Description |
---|---|---|
Label* Â Default Value:Â AlloyDB Execute | String | Specify a unique name for the Snap. Â |
SQL Statement  Default Value: Â
| String/Expression | Specify the SQL statement to execute on the server. We recommend you to add a single query in the SQL Statement field. Scenarios to successfully execute your SQL statements You must understand the following scenarios to successfully execute your SQL statements: Scenario 1: Executing SQL statements without expressions
Scenario 2: Executing SQL queries with expressionsÂ
Note: Table name and column names must not be provided as bind parameters. Only values can be provided as bind parameters. |
Query type  Default Value: Auto | Dropdown list/Expression | Select the type of query for your SQL statement (Read or Write). When Auto is selected, the Snap tries to determine the query type automatically. |
Pass through
| Checkbox | Select this checkbox to pass the input document to the output view under the key |
Ignore empty result
| Checkbox | Select this checkbox to not write any document to the output view when a SELECT operation does not produce any result. |
Number of Retries
| Integer/Expression | Specify the maximum number of retry attempts the Snap must make in case there is a network failure and is unable to read the target file. The request is terminated if the attempts do not result in a response.
|
Retry Interval (Seconds)
| Integer/Expression | Specify the time interval between two successive retry requests. A retry happens only when the previous attempt results in an exception. |
Auto Commit
| Dropdown list | Choose one of the following options to override the state of the Auto commit on the account.Â
|
Snap Execution Default Value:Â Execute only | Dropdown list | Select one of the following three modes in which the Snap executes:
|
Snap Pack History
Related Links
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.