Read and parse JSON in SQL / Teradata

Raymond Tang Raymond Tang 2841 1.26 index 5/29/2019

JSON is commonly used in modern applications for data storage and transfers. Pretty much all programming languages provide APIs to parse JSON.

From Teradata version 15.0, JSON shredding functions are added. JSONExtractValuefunction can be used to extract JSON data from JSON object.  NEW JSON can be used to convert string to JSON object.

In Teradata JSON native data type is also supported. Shredding functions allow you to extract vJSON documents up to 16MB in size.

Code snippet

SELECT jsonObj.Name AS Name,
    jsonObj.JSONExtractValue('$.Value') AS "Value"
    FROM
    (
    SELECT NEW json('{"Name":"A","Value":2}') AS jsonObj) AS r;
sql teradata

Join the Discussion

View or add your thoughts below

Comments