16.10 - JavaScript Object Notation - Parallel Transporter

Teradata Parallel Transporter Reference

Parallel Transporter
Release Number
July 2017
Content Type
Programming Reference
Publication ID
English (United States)

Teradata PT supports loading JavaScript Object Notation (JSON) data into, and extracting JSON data from, Teradata Database tables.

The wire protocol between Teradata PT and the Teradata Database treats JSON as a CLOB.

Depending on how the JSON columns are defined in the Teradata PT schema, Teradata PT uses one of the following two methods to load JSON data into, or extract JSON data from, the Teradata Database:

  • Inline
  • Deferred

The JSON columns in the Teradata PT schema must have a length in bytes.

Only the TPT SQL Selector operator can extract JSON data from a Teradata table.

Only the TPT SQL Inserter operator can load JSON data into a Teradata table.

Only the TPT Data Connector operator can read JSON data from, and write JOS data to, a file.

For more information on CLOB, see Large Objects.