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, Update, and Stream operators 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.