METADATA JSON Method | Teradata Vantage - METADATA - Advanced SQL Engine - Teradata Database

JSON Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
uwa1591040057999.ditamap
dita:ditavalPath
uwa1591040057999.ditaval
dita:id
B035-1150
lifecycle
previous
Product Category
Teradata Vantage™

A JSON method to return metadata on the document.

This method returns a JSON object with the following format:

{
    “size”: Total uncompressed size of the document.
    “depth”: Levels of nesting (starts at 1).
    “keycnt”: Number of keys.
    “objcnt”: Number of values that are Objects.
    “arycnt”: Number of values that are Arrays.
    “strcnt”: Number of values that are Strings.
    “nbrcnt”: Number of values that are Numbers.
    “boolcnt”: Number of values that are “true” or “false”.
    “nullcnt”: Number of values that are “null”.
    “keylen”: Minimum, maximum, and average number of characters in the keys.
}