JSON_EXTRACT_DOT_NOTATION_UDF
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Definition
User-defined function (UDF) that reproduces dot notation used to querying of values inside JSON objects.
JSON_EXTRACT_DOT_NOTATION_UDF(JSON_OBJECT VARIANT, JSON_PATH STRING)
Parameters
JSON_OBJECT
VARIANT
The JSON variable from which to extract the values.
JSON_PATH
STRING
The JSON path that indicates where the values are located inside the JSON_OBJECT.
Returns
The values specified by the JSON_PATH inside the JSON_OBJECT.
Migration example
Input:
SELECT CAST(varcharColumn AS JSON(2000))..name FROM variantTest;
Output:
SELECT
--** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'JSON_EXTRACT_DOT_NOTATION_UDF' INSERTED. **
JSON_EXTRACT_DOT_NOTATION_UDF(PARSE_JSON(varcharColumn), '$..name')
FROM
variantTest;
Last updated