Query editor
with vault_label_json as (selecthttp_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/1/vaults.json') as eth_json,http_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/8453/vaults.json') as base_json,http_get('https://raw.githubusercontent.com/euler-xyz/euler-labels/refs/heads/master/146/vaults.json') as sonic_json),vault_labels as (-- select-- 'ethereum' as blockchain,-- from_hex(key) as vault,-- json_extract_scalar(value, '$.name') as name,-- json_extract_scalar(value, '$.description') as description,-- json_extract_scalar(value, '$.entity') as entity-- from vault_label_json,-- unnest(try_cast(json_extract(eth_json, '$') as map(varchar, json))) as key_value(key, value)-- union allselect'base' as blockchain,from_hex(key) as vault,json_extract_scalar(value, '$.name') as name,json_extract_scalar(value, '$.description') as description,json_extract_scalar(value, '$.entity') as entityfrom vault_label_json,unnest(try_cast(json_extract(base_json, '$') as map(varchar, json))) as key_value(key, value)-- union all-- select-- 'sonic' as blockchain,-- from_hex(key) as vault,-- json_extract_scalar(value, '$.name') as name,-- json_extract_scalar(value, '$.description') as description,-- json_extract_scalar(value, '$.entity') as entity-- from vault_label_json,-- unnest(try_cast(json_extract(sonic_json, '$') as map(varchar, json))) as key_value(key, value))select * from vault_labels where blockchain='base'