Teradata Snap Pack

Teradata Snap Pack

This page is no longer maintained (May 13, 2026). To access the most current content, go to https://docs.snaplogic.com/snaps/sp-teradata/sp-teradata-about.html

In this article

Overview

Teradata’s leading portfolio of big data analytic solutions, integrated marketing applications, and services can help organizations gain a sustainable competitive advantage with data. 

Use Snaps in this Snap Pack to export data from a Teradata database by providing a table name and configuring the connection. 

Supported Versions

This Snap Pack is tested against Teradata version 16.20.22.01.

You must have tdgssconfig-15.00.00.33.jar and terajdbc4-15.00.00.33.jar of Teradata.
Learn more about the Teradata Tools & Utilities you need for your platform.

Snap Pack History

Release 

Snap Pack Version

Date

Type

  Updates

Release 

Snap Pack Version

Date

Type

  Updates

May 2026

main34730

May 13, 2026

Stable

Updated and certified against the current SnapLogic Platform release.

November 2025

443patches33325

Dec 16, 2025

Latest

Added Teradata Multi Execute Snap that enables you to execute multiple write statements as a single transaction for every input document.

November 2025

main33142

Nov 12, 2025

Stable

Updated and certified against the current SnapLogic Platform release.

August 2025

main32088

Aug 13, 2025

Stable

Updated and certified against the current SnapLogic Platform release.

May 2025

main31019

May 14, 2025 

Stable

Updated and certified against the current SnapLogic Platform release.

February 2025

440patches30375

Mar 31, 2025 

Latest

Fixed an issue with the following Teradata Snaps, where the password was visible in the script temp file while the Snap was executing:

February 2025

main29887

Feb 12, 2025 

Stable

Updated and certified against the current SnapLogic Platform release.

November 2024

439patches29842

Feb 6, 2025 

Latest

Fixed an issue with Teradata Fastload Snap getting paused because of column length overflow when data contained special characters.

November 2024

439patches29297

Dec 20, 2024 

Latest

Enhanced the following Teradata Snaps with the Query band field that logs the SnapLogic pipeline, project, and Teradata database information in Teradata to help associate metadata with each query when it is executed:

November 2024

439patches29265

Dec 5, 2024 

Latest

  • Fixed an issue with the Teradata FastLoad Snap that validated successfully even when the fast load was paused due to an error. The Snap now displays the error with the appropriate reason for the pause.

  • Fixed an issue with the Teradata FastLoad Snap where an invalid output document was generated when an error occurred while fetching the table schema, and the Create table if not present, checkbox is deselected. Now, the Snap correctly displays an error in such cases, regardless of the checkbox status.

November 2024

main29029

Nov 13, 2024 

Stable

Updated and certified against the current SnapLogic Platform release.

August 2024

438patches29017

Nov 12, 2024 

Latest

Fixed an issue with the Teradata Snaps that caused errors because of invalid account credentials when the username or password included any of the following special characters:

) ( ! \ # $ % ^ & * " ' ? | ; ~ -`

August 2024

main27765

Aug 21, 2024 

Stable

Upgraded the org.json.json library from v20090211 to v20240303, which is fully backward compatible.

May 2024

437patches26471

Jun 10, 2024 

Latest

The jOOQ library for Teradata Snap Pack is upgraded from v3.9.1 to v3.17.3. This upgrade will be part of the GA release on August 14, 2024 (Stable release). Pipelines using the Teradata Snaps are not impacted after the jOOQ upgrade.

May 2024

main26341

May 8, 2024 



Stable

Updated and certified against the current SnapLogic Platform release.

February 2024

main25112

Feb 14, 2024 

Stable

Updated and certified against the current SnapLogic Platform release.

November 2023

main23721

Nov 8, 2023 

Stable

Updated and certified against the current SnapLogic Platform release.

August 2023

main22460

Aug 16, 2023 



Stable

The Teradata Execute Snap now includes a new Query type field. When Auto is selected, the Snap tries to determine the query type automatically.

May 2023

main21015

May 10, 2023 

Stable

Upgraded with the latest SnapLogic Platform release.

February 2023

main19844

Feb 9, 2023 

Stable

Upgraded with the latest SnapLogic Platform release.

November 2022

main18944

Nov 10, 2022 

Stable

The TPT Insert Snap now creates the target table only from the table metadata of the second input view when the following conditions are met:

  • The Create table if not present checkbox is selected.

  • The target table does not exist.

  • The table metadata is provided in the second input view.

August 2022

main17386

Aug 11, 2022 

Stable

Upgraded with the latest SnapLogic Platform release.

4.29 Patch

429patches16235

Jul 21, 2022 

Latest

Fixed an issue with Teradata Execute Snap where the Snap did not display valid error message when the delete condition is invalid.

4.29

main15993

May 14, 2022 

Stable

Enhanced the Teradata FastExport Snap with Character Set dropdown list to support encoding of data when you export data from the Teradata Database.

4.28

main14627

Feb 12, 2022 

Stable

Upgraded with the latest SnapLogic Platform release.

4.27

main12833

Nov 13, 2021 

Stable

Enhanced the Teradata Execute Snap to invoke stored procedures.

4.26

main11181

Aug 14, 2021 

Stable

Upgraded with the latest SnapLogic Platform release.

4.25 Patch

425patches11008

Aug 4, 2021 

Latest

Improved the error messages for all the Snaps in the Teradata Snap Pack where the Snaps fail with a null pointer exception error when the account reference provided is invalid. 

4.25

main9554

May 8, 2021 

Stable

Upgraded with the latest SnapLogic Platform release.

4.24 Patch

424patches8799

Mar 5, 2021 

Latest

  • Enhanced the Teradata Execute Snap by adding a new field, Advanced options, which extends support with microsecond precision for TIMESTAMP data type.

  • Fixed an issue in the TPT Load Snap where the Snap failed to load data into the table while creating an output.

  • Fixed an issue with the TPT Load Snap wherein now a null value is loaded as null and empty string is loaded as empty string.

    • This fix may cause existing pipelines to fail if empty string values are expected to be loaded as null.

    • Following are the new configurations:

      • VARCHAR QuotedData= Optional

      • VARCHAR OpenQuoteMark= \”

      • VARCHAR NullColumns= Yes

4.24

main8556

Feb 13, 2021

Stable

Enhanced the Teradata Select Snap to return only the selected output fields or columns in the output schema (second output view) using the Fetch Output Fields In Schema check box. If the Output Fields field is empty all the columns are visible.

4.23

main7430

Nov 14, 2020 

Stable

Fixes the multi-line value issue and issue in the TPT Load Snap where the Snap writes null for both an empty string and null values in the input data. The fix for this issue was to add the following three lines in the script and wrap all the values in double quotes unless they are null while writing the input data into a temp CSV file. 
VARCHAR QuotedData = 'Optional',
VARCHAR OpenQuoteMark = '\"'
VARCHAR NullColumns = 'Yes'

This fix may cause existing pipelines to fail if empty string values are expected to be loaded as null.

4.22

main6403

Sep 12, 2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.21 Patch

421patches6272

Jul 27, 2020 

Latest

Fixed the issue where Snowflake SCD2 Snap generates two output documents despite no changes to Cause-historization fields with DATE, TIME and TIMESTAMP Snowflake data types, and with Ignore unchanged rows field selected.

4.21 Patch

421patches6144

Jul 20, 2020 

Latest

Fixed the following issues with DB Snaps:

  • The connection thread waits indefinitely causing the subsequent connection requests to become unresponsive.

  • Connection leaks occur during Pipeline execution.

4.21 Patch

MULTIPLE8841

May 19, 2020 

Latest

Fixed the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. 

4.21

snapsmrc542

May 9, 2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.20

snapsmrc535

Feb 8, 2020 

Stable

Upgraded with the latest SnapLogic Platform release.

4.19 Patch 

db/teradata8414

Dec 13, 2019 

Latest

Fixed an issue with the TPT Update Snap wherein the Snap is unable to perform operations when:

  • An expression is used in the Update condition property.

  • Input data contain the character '?'.

4.19

snaprsmrc528

Nov 14, 2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.18

snapsmrc523

Aug 10, 2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.17

ALL7402

Jun 11, 2019 

Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17

snapsmrc515

Jun 11, 2019 

Latest

  • Fixed an issue with the Teradata Execute Snap wherein the Snap would send the input document to the output view even if the Pass through field is not selected in the Snap configuration. With this fix, the Snap sends the input document to the output view, under the key original, only if you select the Pass through field.

  • Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16

snapsmrc508

Feb 16, 2019 

Stable

Upgraded with the latest SnapLogic Platform release.

4.15 Patch 

db/teradata6338

Dec 5, 2018 

Latest

Replaced Max idle time and Idle connection test period properties with Max life time and Idle Timeout properties respectively, in the Account configuration. The new properties fix the connection release issues that were occurring due to default/restricted DB Account settings.

4.15

snapsmrc500

Dec 15, 2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.14

snapsmrc490

Aug 11, 2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.13

snapsmrc486

May 12, 2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.12

snapsmrc480

Feb 17, 2018 

Stable

Upgraded with the latest SnapLogic Platform release.

4.11

snapsmrc465

Nov 11, 2017 

Stable

Upgraded with the latest SnapLogic Platform release.

4.10

snapsmrc414

Aug 12, 2017 

Stable

Added Auto commit property to the Select and Execute Snaps at the Snap level to support overriding of the Auto commit property at the Account level.

4.9.0 Patch

teradata3077

Jun 1, 2017 

Latest

Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap

4.9

snapsmrc405

May 13, 2017 

Stable

  • Enhanced the Output view of the Snap with Order Summary field that displays the output values (added to the out, err, status, classpath and env fields of the single output view that display the subprocess only).

  • Teradata Export to HDFS Snap supported with Dynamic account.

4.8

snapsmrc398

Feb 11, 2017 

Stable

  • Introduced the TPT Delete, Insert, Load, Upsert and Update Snaps in this release.

  • Introduced Teradata Export to HDFS Snap in this release.

  • Info tab added to accounts.

  • Database accounts now invalidate connection pools if account properties are modified and login attempts fail.

4.7

snapsmrc382

Nov 23, 2016 

Stable

  • Introduced the Teradata FastLoad and Execute Snaps in this release.

  • Migration impact: In Teradata FastExport, the values of the Data Format field have been standardized to be in all caps. Existing pipelines that use the values of Binary, Text, or Unformatted will fail unless the new value of BINARY, TEXT, or UNFORMAT are used.

4.6

snapsmrc362

Aug 13, 2016 

Stable

Snap Pack introduced in 4.6.0. This includes only Teradata extract functionality to move data out of Teradata database using the FastExport Utility. It does not include Snaps for load, select, insert, delete, execute or others at this time. It also does not utilize the Teradata Parallel Transporter to extract data.