Json in synapses rowset

Vineet S 950

Hi, when trying below code in openrowset .... Unable to get in tabular format {

"ONE": "JJJJ",

"TWO": "HH",

"THREE": "JJKK",

"4": "HJJJJ",

"5": "UUUU",

"_6": "UUUU",

"_7": "dbJJJJ",

"_8": "4GGG",

"_9": "EE/",

"_ts": "WW"

}

Ganesh Gurram 945 Reputation points Microsoft Vendor

2024-09-24T09:33:18.1866667+00:00

@Vineet S - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Ganesh Gurram 945 Reputation points Microsoft Vendor

2024-09-23T08:54:51.89+00:00

@Vineet S - Thanks for the question and using MS Q&A platform.

In additional to my response provided here: Openrowset

You need to apply CROSS APPLY OPENJSON(jsonContent) to view in tabular format.

For more details, refer to video here: Query all JSON formats in Azure Synapse Analytics | SQL Pool |

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Ganesh Gurram 945 Reputation points Microsoft Vendor

2024-09-25T09:18:07.98+00:00

@Vineet S - Just checking in to see if the above answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer