...
Field Name | Field Type | Description | ||
---|---|---|---|---|
Label* Default Value: AlloyDB Delete | String | Specify a unique name for the Snap. | ||
Schema Name Default Value: | String/Expression | The database schema name. Selecting a schema filters the Table name list to show only those tables within the selected schema. | ||
Table Name Default Value: | String/Expression | Table name to execute the delete on. The values can be passed using the pipeline parameters but not the upstream parameter. | ||
Delete Condition (Truncates Table if empty) Default Value: None Without using expressions
Using expressions
| String/Expression | Specify a valid WHERE clause for the delete condition. The delete condition may also be passed through an upstream Snap or through the Pipeline parameters. If you leave this field blank, the Snap truncates the table.
Here is an example of a delete statement. | ||
Number of Retries Default Value: 0 | 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) Default value: 1 | Integer/Expression | Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception. | ||
Snap Execution Default Value: Execute only | Dropdown list | Select one of the following three modes in which the Snap executes:
|
...