Snaplogic Generic JDBC
Hello, I’m having a small problem with the timestamp between the results coming from Snaplogic Generic JDBC and SQL Teradata SQL assistant. Main issue is that the timestamp in Snaplogic results shows a different time compared to Teradata SQL assistant. Could you please let me know what I need to change on the Snaplogic side in order to match the timestamp results. Same query used in both places. The format is irrelevant just want to have same date and time e.g. 1st of OCT 2021 00:00:07 instead of 05:00:07 (as in Snaplogic results). Best Regards, Jarek
Move data from a relational database into Teradata
Created by @pavan This pattern pipeline migrates data from a relational database, like MySQL, to Teradata. Configuration Note: Sample database and table names are used within the Snaps to give you an idea on expected values. Replace them with your system information. Sources: MySQL table Targets: Teradata Snaps used: MySQL Select, TPT Load, Teradata Execute Downloads 4.8_TPT FLoad.slp (5.3 KB)
Reference Pipeline : To get schema details for a Teradata Table
As part of ones implementation, one would need to query the metadata/table schema for a database table. The following pipeline is used to get field metadata for a given table in Teradata. You can call it from any pipeline by using the Pipeline Execute Snap and make sure you provide the schema name and table name When calling the above from a master pipeline, it would look like below. In this example, we are passing the table schema from Teradata (for the table) to the input view (second view) of CSV Parser. The CSV Parser Snap has an optional second input view that takes in an input schema (csv of field names). Source: Teradata Target: master pipeline Snaps used: JDBC, Mapper, JSON Generator Download Attached is the reference pipeline to get Teradata Schema Pattern - Teradata - Get columns for Table_2018_06_25.slp (11.1 KB) The master pipeline can be found in the topic: Teradata to Cloud Data warehouse : Teradata to Azure SQL Data WarehouseTeradata to Cloud Data warehouse : Teradata to Azure SQL Data Warehouse
Teradata TPT FastExport Snap enables one to export large amounts of data out of Teradata very efficiently. On the target side if you are moving data into the Azure SQL Data warehouse, use the Azure polybase bulkload. If you were to move data to Redshift, then use the Redshift Bulkload Snap. Below is an example how you can configure the Teradata TPT fast export snap. The prerequisite is that you need to install the Teradata TPT utilities on every node of your Snaplex. Snaps Used: TPT FastExport, File Reader, CSV Formatter, CSV Formatter, Pipeline Execute, Azure Polybase Bulkload Download Teradata to Azure SQL Data Warehouse_2018_06_25.slp (10.0 KB) This pattern also calls the Pattern described in Reference Pipeline : To get schema details for a Teradata Table
Teradata Snap Pack on a Windows Node?
Hello everyone, We are attempting to use the Teradata TPT snap from the Teradata snap pack and are running into a road block in giving the snap the location of tbuild.exe in the “TBUILD location” field. I can’t get it to find the file no matter what combination of slashes and folder paths I can think of. "C:\folder" “C:/folder/” “C://folder//” etc… Has anybody else gotten this to work? The documentation doesn’t specify the format and support just says they haven’t thoroughly tested it on windows yet. Thanks in advance, Brett