JSON Data Type | VantageCloud Lake - JSON Data Type - 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
JSON UNICODE/LATIN is only supported on the Block File System on the primary cluster. It is not available for the Object File System.
The JSON data type is provided by Teradata Vantage™. You can use the JSON data type for JSON format data.
  • JSON data type content is stored in an optimized format depending on the size of the data.
  • The user is not responsible for executing the CREATE TYPE statement for the JSON data type. JSON data types need not be created using DDL by the user as the JSON data type exists in the database.
  • The JSON data type cannot be created, dropped, or altered by the user.
  • There are two points of commonality between all uses of the JSON data type in any valid location:
    • The maximum length of any instance of the JSON data type is variable. You may set the maximum length of the JSON instance, otherwise the default maximum length is used.
    • The CHARACTER SET for the text of the JSON data type can be either UNICODE or LATIN. If you do not specify the character set, the default character set of the user is used.