base AS (

SELECT

livequery.live.udf_api ('https://api.llama.fi/chains') AS response

)

VALUE:chainId::INT AS chainID,

VALUE:cmcId::INT AS cmcID,

VALUE:gecko_id::STRING AS geckoID,

VALUE:name::STRING AS NAME,

VALUE:tokenSymbol::STRING AS symbol,

VALUE:tvl::FLOAT AS tvl

base,

LATERAL FLATTEN(input => response:data);