JSON_VALUE UDF
Translation reference to convert Oracle JSON_VALUE function to Snowflake
Some parts in the output code are omitted for clarity reasons.
Description
As per Oracle's documentation, this function uses the SQL/JSON Path Expression to request information about a portion of a JSON instance. The returning value is always a scalar value, else the function returns NULL
by default.
The JSON_VALUE_UDF is a Snowflake implementation of the JSONPath specification that uses a modified version of the original JavaScript implementation developed by Stefan Goessner.
Sample Source Patterns
Setup Data
Run these queries to run queries in the JSON_VALUE Patterns section.
Oracle
IN -> Oracle_01.sql
Snowflake
OUT -> Oracle_01.sql
JSON_VALUE Patterns
Oracle
IN -> Oracle_02.sql