This Snap has at most one document input view. The input document contains map data with each document mapped to a single record by matching document field names with table column names.

• Mapper
• JSON Generator
• File Reader

This Snap has at most one document output view.

Label

String

Required.

Required. Specify a unique name for the Snap. Modify this to be more appropriate, especially if more than one of the same Snaps is in the pipeline.

Default value: Redshift - Update

Example: Redshift - Update

Schema name

String/Expression/ Suggestion

Specify the database schema name. Leave this field blank to use the default schema.

Default value: N/A

Example: public

Table name

String/Expression/ Suggestion

Required.

Specify the name of the table to update.

Default value: N/A

Example: employees

Update condition

String/Expression/ Suggestion

Specify the SQL WHERE clause of the update statement. You can define specific values or columns to update (Set condition) in the upstream Snap, such as Mapper Snap, and then use the WHERE clause to apply these conditions on the columns sourced from the upstream Snap. For instance, here is a sample of an Update SQL query:

UPDATE table_name
SET column1 = value1, column2 = value2,
WHERE condition;

If the Update Condition field is left blank, the condition is applied on all the records of the target table.

In certain scenarios where you want to use specific data from the upstream Snaps, and do not want to change that data in the Update Snap, then you need to place the data in the original structure of the input document. Hence, we recommend that you use the format for Update condition and input data format as shown below:

{
"valueToUpdate" : "true",
"original": {
"col1" : "KEY"
}
}

Refer to the example to understand how to use the Update Condition.

Default value: N/A

Example:

Without using expressions

• EmpId = 12
• email = '[email protected]'

Using expressions

• "EMPNO=$EMPNO and ENAME=$EMPNAME"
• email = $email
• emp=$emp
• "emp='" + $emp + "'"
• "EMPNO=" + $EMPNO + " and ENAME='" + $EMPNAME+ "'"

Number of retries

Integer

Specify the maximum number of retry attempts the Snap must make in case of network failure.

Default value: 0

Example: 3

Retry interval (seconds)

Integer

Specify the time interval between two successive retry requests. A retry happens only when the previous attempt resulted in an exception.

Default value: 1

Example: 10

Snap execution

Dropdown list

Select one of the three modes in which the Snap executes. Available options are:

• Validate & Execute: Performs limited execution of the Snap and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.
• Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.
• Disabled: Disables the Snap and all Snaps that are downstream from it.

Default value: Execute only

Example: Validate & Execute