TD_JSONSHRED Result Types - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

TD_JSONSHRED returns a derived table with rows that have at least two columns.

The first column is the identifier column that was retrieved by the json_documents_retrieving_expression. This column is passed through, unchanged, from the results of that retrieving expression query.

The last columns returned are from the shredded JSON data, and must conform to the format and data types defined by COLEXPR and RETURNTYPES.

If the original json_documents_retrieving_expr returned additional columns between the ID and JSON data columns, these pass-through columns are returned unmodified between the ID column and the columns of shredded JSON data.