{
  "area": {
    "id": "TEST1"
    "value": "TEST1"
  }, 
{  "testcom": {
     "conditions": [
     {
        "assignedto": {
          "workphone":NULL
        },
        "isClause":false
     }
    ],   
    "iscritical": true,
    "value": "Conditon"
 }
} 
} 

Hi, the output of json structure is as above

questions answer      isClause
testcom   conditions  FALSE

Need the output as above, i have used the below SQL, not able to get the output as expected, the source column is Variant, can someone please check…

select 
lvl_1.key,
lvl_1.value 
from 
    (
    select 
    parse_json(col1) as src 
    from 
    table1
    )xyz 
,lateral flatten(input => xyz.src) lvl_1,
,lateral flatten(input => lvl_1.value) lvl_2,
,lateral flatten(input => lvl_2.value:isClause) lvl_3