Teradata provides shredding functionality that allows you to extract values from JSON documents and store the extracted data in relational format. Data from a JSON instance can be used to INSERT, UPDATE, UPSERT, or DELETE from one or more existing tables.
Functions are provided to create a temporary table and/or update tables based on a single JSON instance or a group of JSON instances.
- JSON_TABLE
- This is a table operator which takes a JSON instance and creates a temporary table based on a subset, or all, of the data contained in the JSON instance.
- JSON_SHRED_BATCH and JSON_SHRED_BATCH_U
- The JSON_SHRED_BATCH and JSON_SHRED_BATCH_U stored procedures load relational tables with data extracted from JSON instances.
The table operator and these procedures operate on JSON documents stored in text format as well as the binary formats.