Questions tagged [openjson]
The openjson tag has no usage guidance.
4
questions
2
votes
3
answers
185
views
Performance implications of OPENJSON in view
Earlier today, I needed to put some small data quickly in a SQL Server database:
CREATE VIEW MyView AS SELECT * FROM OPENJSON('[ ... ]') WITH ( colA int, etc. );
intending to go back and replace this ...
- 21
0
votes
0
answers
23
views
Azure Synapse query to multiple JSON files in data lake, parse data into table format
I want to query RAW telemetry data stored in JSON format in my data lake. I am using Azure Synapse to query the files.
I can successfully pull the data I want into a result table, but I struggle to ...
- 193
2
votes
1
answer
378
views
Detect keys whose values are objects or arrays automatically in SQL JSON Query
I have these JSON:
Application 1:
{
"business_industry": "Agriculture",
"docs": [
{
"internal": false,
"type": "Asset & ...
- 135
1
vote
1
answer
218
views
Querying JSON key with values as JSON in SQL Server
I have these JSON:
Application 1:
{
"business_industry": "Agriculture",
"docs": [
{
"internal": false,
"type": "Asset & ...
- 135