JSON Data Type | JSON Publishing | VantageCloud Lake - JSON Publishing - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Vantage provides the following functionality for composing JSON documents:
  • The SELECT AS JSON statement composes data from table columns into a text format JSON document.
    This statement is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
  • The JSON_PUBLISH table operator composes input parameters into JSON data of any supported format, including binary storage formats such as BSON and UBJSON.
  • The JSON_AGG and JSON_COMPOSE functions composes input parameters into a text format JSON document.