...
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.We recommend you to add a single query in the SQL Statement field. |
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 This field applies only to queries with the SELECT statement. |
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 attempts to be made to receive a response. 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.
Auto commit may be enabled for certain use cases if the AlloyDB JDBC driver is used in either the Redshift, AlloyDB, or generic JDBC Snap. However, the JDBC driver may cause out of memory issues when SELECT statements are executed. In such cases, Auto Commit in the Snap should be set to False and the Fetch size in the Account settings can be increased for optimal performance. Behavior of DML Queries in Database Execute Snap when auto-commit is false
|
Snap Execution Default Value: Execute only | Dropdown list | Select one of the following three modes in which the Snap executes:
|
...