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;