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:
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.