Teradata PT supports loading JavaScript Object Notation (JSON) data into, and extracting JSON data from, database tables.
The wire protocol between Teradata PT and the 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 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 database table.
Only the TPT SQL Inserter, Update, and Stream operators can load JSON data into a database table.
Only the TPT DataConnector operator can read JSON data from, and write JOS data to, a file.
For more information on CLOB, see Large Objects.