livequery.live.udf_api(

'GET',

'https://science.flipsidecrypto.xyz/googlesheets/readsheet',

{ 'Content-Type': 'application/json' },

{

'sheets_id' : '1isXwTpJlxMClz1Kg0tkSNMwhd8Z944IgprPULx_aqWg',

'tab_name' : 'Sheet1'

}

) as result

from DUAL

),

data AS (

select result:data as json_result_must_pivot from res

d.value:"ID"::VARCHAR as ID,

TO_NUMBER(d.value:"Value") as Value,

d.value:"Class"::VARCHAR as Class

FROM

data,

LATERAL FLATTEN(input => data.json_result_must_pivot::VARIANT) d