Read JSON data from a table and parse it to rows and columns

#SQLwithManoj #SQLServer #SQLandJSON #DatabaseBasics

[waisyousofi]

Thank you so much for the great and unique content.
it's been 4 hours I was looking for an example like this.

[basilprivitera]

Great work Manoj, your explanation made it very easy to understand !! Microsoft should employ you in the "Documentation people actually find useful" department!! Thanks and greetings from AUS.

[SwatiSingh-cyrv]

Hi, can you please let us know how to extract the same data in DB2 using SQL?

[mayurjain]

After applying cross apply I tried to parse data in similar way as in video but showing null values for 2nd and 3rd column i.e., in video 'orderdate' and 'totaldue' any idea why?

[waisyousofi]

sir can you create a query which gives the length of json as per key.

[srinivasreddynalla]

Actually I want to rename key and values to some names .my json data key name are not same so I am trying to store all those keys and values in 2 columns and then load into table, is this possible?if yes please let me know

[rohini]

This is very helpful. Thank you for this explanation. When the JSON array is variable how do we write the query to read it dynamically?

[naveenchristopher]

Wow great. How to do same in oracle sql.

[SurajKumar-kkwz]

Is this same code will be working in MySQL workbench or not?

[VivekSharma_IT]

Hi
I have a Databricks delta table containing 2 fields: eventdate and json_dump. The field json_dump contains the data in json format. How do I extract this using sql query? I tried with your approach but getting mismatch input error.

Thanks