Teradata Sink
The Teradata sink is available in the Hub.
Plugin version: 1.7.0
Writes records to a Teradata table. Each record will be written to a row in the table.
Use this sink when you need to write to a Teradata table. Suppose you periodically build a recommendation model for products on your online store. The model is stored in a FileSet and you want to export the contents of the FileSet to a Teradata table where it can be served to your users.
Column names would be autodetected from input schema.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Reference Name | No | Required. Name used to uniquely identify this sink for lineage, annotating metadata, etc. |
Driver Name | No | Required. Name of the JDBC driver to use. |
Host | Yes | Required. Host that Teradata is running on. Default is localhost. |
Port | Yes | Required. Port that Teradata is running on. Default is 1025. |
Database | Yes | Required. Teradata database name. |
Table Name | Yes | Required. Name of the table to export to. |
Username | Yes | Optional. User identity for connecting to the specified database. |
Password | Yes | Optional. Password to use to connect to the specified database. |
Connection Arguments | Yes | Optional. A list of arbitrary string key/value pairs as connection arguments. These arguments will be passed to the JDBC driver as connection arguments for JDBC drivers that may need additional configurations. |
Example
Suppose you want to write output records to “users” table of Teradata database named “prod” that is running on “localhost”, port 1025, as “root” user with “root” password (Ensure that the driver for Teradata is installed. You can also provide driver name for some specific driver, otherwise “teradata” will be used), then configure the plugin with:
Property | Value |
---|---|
Reference Name |
|
Driver Name |
|
Host |
|
Port |
|
Database |
|
Table Name |
|
Username |
|
Password |
|
Data Types Mapping
Teradata specific data types mapped to string and can have multiple input formats and one ‘canonical’ output form. To figure out proper formats, see Teradata data types documentation.
Teradata Data Type | CDAP Schema Data Type |
---|---|
BYTEINT | INT |
SMALLINT | INT |
INTEGER | INT |
BIGINT | LONG |
DECIMAL/NUMERIC | DECIMAL |
FLOAT/REAL/DOUBLE PRECISION | DOUBLE |
NUMBER | DECIMAL |
BYTE | BYTES |
VARBYTE | BYTES |
BLOB | BYTES |
CHAR | STRING |
VARCHAR | STRING |
CLOB | STRING |
DATE | DATE |
TIME | TIME_MICROS |
TIMESTAMP | TIMESTAMP_MICROS |
TIME WITH TIME ZONE | TIME_MICROS |
TIMESTAMP WITH TIME ZONE | TIMESTAMP_MICROS |
INTERVAL YEAR | STRING |
INTERVAL YEAR TO MONTH | STRING |
INTERVAL MONTH | STRING |
INTERVAL DAY | STRING |
INTERVAL DAY TO HOUR | STRING |
INTERVAL DAY TO MINUTE | STRING |
INTERVAL DAY TO SECOND | STRING |
INTERVAL HOUR | STRING |
INTERVAL HOUR TO MINUTE | STRING |
INTERVAL HOUR TO SECOND | STRING |
INTERVAL MINUTE | STRING |
INTERVAL MINUTE TO SECOND | STRING |
INTERVAL SECOND | STRING |
ST_Geometry | STRING |
Created in 2020 by Google Inc.