In this article

1 Overview
- 1.1 Snap Type
- 1.2 Prerequisites
- 1.3 Support for Ultra Pipelines
- 1.4 Known Issues
2 Snap Views
3 Snap Settings
4 Examples
- 4.1 Teradata Multi-Execute Operations
- 4.2 Downloads
5 Snap Pack History

Overview

You can use this Snap to execute multiple write statements as a single transaction for every input document.

Snap Type

The Teradata Multi Execute Snap is a Write-type Snap.

Prerequisites

A valid account with the required permissions.

Support for Ultra Pipelines

Works in Ultra Pipelines.

Known Issues

Stored procedures are not supported with Multi Execute Snap.

Snap Views

Type	Format	Number of Views	Examples of Upstream and Downstream Snaps	Description

Type

Format

Number of Views

Examples of Upstream and Downstream Snaps

Description

Input

Document

Min: 0
Max: 1

Mapper
Copy

Each input document can contain data that will be used in your SQL statements.
Optional input: The snap can also run without any input if your SQL queries are static.

Output

Document

Min: 0
Max: 1

Mapper
Router

Returns actual data rows as documents or execution status information. Each row is one output document. Results from different statements are combined in the output stream.

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 when running the pipeline by choosing one of the following options from the When errors occur list under the Views tab:

Stop Pipeline Execution: Stops the current pipeline execution if the Snap encounters an error.
Discard Error Data and Continue: Ignores the error, discards that record, and continues with the remaining records.
Route Error Data to Error View: Routes the error data to an error view without stopping the Snap execution.

Learn more about Error handling in Pipelines.

Snap Settings

Expression : JavaScript syntax to access SnapLogic Expressions to set field values dynamically (if enabled). If disabled, you can provide a static value. Learn more.
SnapGPT : Generates SnapLogic Expressions based on natural language using SnapGPT. Learn more.
Suggestion : Populates a list of values dynamically based on your Account configuration.
Upload : Uploads files. Learn more.

Learn more about the icons in the Snap Settings dialog.

Field Name	Field type	Description

Field Name	Field type	Description
Label*	String	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. Default Value: Teradata Multi Execute Example: Teradata Multi Execute
SQL statements	List of SQL statements to be executed as a single transaction.
SQL statement*	String/Expression	The SQL statement to be executed. Each SQL statement execution produces output documents containing the result set Default Value: N/A Example: `INSERT INTO employees` `VALUES (102, 'Jane', 'Smith', 'HR', DATE '2025-02-01');`
Snap Execution	Dropdown list	Select one of the following three modes in which the Snap executes: 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

Examples

Teradata Multi-Execute Operations

The following example pipeline demonstrates the functionality of the Teradata Multi Execute Snap by performing database operations on the target table with the following data types.

Numeric types (INTEGER, BIGINT, DECIMAL, FLOAT)
Character types (CHAR, VARCHAR, CLOB)
Date/Time types (DATE, TIME, TIMESTAMP)
Boolean and BLOB types

Configure the Sequence Snap to generate sequential data to initiate the pipeline flow.
Configure the Mapper Snap to create three SQL statements - an INSERT statement with sample data for various data types, an UPDATE statement to modify character data, and a DELETE statement to remove the inserted record.
Configure the Teradata Multi Execute Snap with the following SQL statements:
1. INSERT: Adds sample records with various data types
2. UPDATE: Modifies existing records
3. DELETE: Removes records
Validate the Snap. On validation, the Snap receives and validates the three SQL statements from the upstream Mapper:

INSERT Statement: INSERT INTO SNAP14255_DataTypes2_perf (col_integer, col_bigint, col_smallint,col_byteint,col_decimal,col_float,col_number,col_char,col_varchar,col_clob,col_date,col_time,col_timestamp,col_boolean) VALUES (12345,9876543210,32000,100,12345.67,3.14159,123456.7890,'FIXEDTEXT','This is varchar text','This is a sample CLOB value',DATE '2025-09-03',TIME '12:34:56',TIMESTAMP '2025-09-03 12:34:56',1 );
UPDATE Statement: update SNAP14255_DataTypes2_perf set col_char = 'Updated Fixed Text' where col_integer ='12345'
DELETE Statement: Delete from SNAP14255_DataTypes2_perf where col_integer ='12345'

Download the pipeline.

Downloads

Download and import the pipeline into the SnapLogic application.
Configure Snap accounts, as applicable.
Provide pipeline parameters, as applicable.

	File	Modified
Labels No labels Preview View	File Example-Teradata-MultiExecute.slp	Dec 10, 2025 by Kalpana Malladi

Snap Pack History

Teradata Snap Pack

Teradata Multi Execute