Teradata Snap Pack
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.
Related Content
- Video Series: Teradata to Snowflake Migration
- Getting started with SnapLogic
August 2023 main22460 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 Stable Upgraded with the latest SnapLogic Platform release. 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. Fixed an issue with Teradata Execute Snap where the Snap did not display valid error message when the delete condition is invalid. Enhanced the Teradata FastExport Snap with Character Set dropdown list to support encoding of data when you export data from the Teradata Database. Enhanced the Teradata Execute Snap to invoke stored procedures. 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.24 Patch 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: 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. 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. This fix may cause existing pipelines to fail if empty string values are expected to be loaded as null. 4.21 Patch 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 Fixed the following issues with DB Snaps: 4.21 Patch Fixed the connection issue in Database Snaps by detecting and closing open connections after the Snap execution ends. 4.19 Patch Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers. 4.15 Patch 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. snapsmrc486 snapsmrc480 snapsmrc414 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 Fixed an issue regarding connection not closed after login failure; Expose autocommit for "Select into" statement in PostgreSQL Execute Snap and Redshift Execute Snap snapsmrc398 snapsmrc382 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.Snap Pack History
Release Snap Pack Version Date Type Updates main21015 February 2023 main19844 Stable Upgraded with the latest SnapLogic Platform release. November 2022 main18944 Stable August 2022 main17386 Stable Upgraded with the latest SnapLogic Platform release. 4.29 Patch 429patches16235 Latest 4.29 main15993 Stable 4.28 main14627 Stable Upgraded with the latest SnapLogic Platform release. 4.27 main12833 Stable 4.26 main11181 Stable Upgraded with the latest SnapLogic Platform release. 4.25 Patch 425patches11008 Latest 4.25 main9554 Stable Upgraded with the latest SnapLogic Platform release. 424patches8799 Latest VARCHAR QuotedData= Optional
VARCHAR OpenQuoteMark= \”
VARCHAR NullColumns= Yes
4.24 main8556 Stable 4.23 main7430 Stable
VARCHAR QuotedData = 'Optional',
VARCHAR OpenQuoteMark = '\"'
VARCHAR NullColumns = 'Yes'4.22 main6403 Stable Upgraded with the latest SnapLogic Platform release. 421patches6272 Latest 421patches6144 Latest MULTIPLE8841 Latest 4.21 snapsmrc542 Stable Upgraded with the latest SnapLogic Platform release. 4.20 snapsmrc535 Stable Upgraded with the latest SnapLogic Platform release. db/teradata8414 Latest Fixed an issue with the TPT Update Snap wherein the Snap is unable to perform operations when: 4.19 snaprsmrc528 Stable Upgraded with the latest SnapLogic Platform release. 4.18 snapsmrc523 Stable Upgraded with the latest SnapLogic Platform release. 4.17 ALL7402 Latest 4.17 snapsmrc515 Latest 4.16 snapsmrc508 Stable Upgraded with the latest SnapLogic Platform release. db/teradata6338 Latest 4.15 snapsmrc500 Stable Upgraded with the latest SnapLogic Platform release. 4.14 snapsmrc490 Stable Upgraded with the latest SnapLogic Platform release. 4.13 Stable Upgraded with the latest SnapLogic Platform release. 4.12 Stable Upgraded with the latest SnapLogic Platform release. 4.11 snapsmrc465 Stable Upgraded with the latest SnapLogic Platform release. 4.10 Stable teradata3077 Latest 4.9 snapsmrc405 Stable 4.8 Stable 4.7 Stable 4.6 snapsmrc362 Stable
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2023 SnapLogic, Inc.