1.6 finding validator test

ZSaed1.6 finding validator test

Updated 2023-02-07

with tx as (

select *

from terra.core.fact_msg_attributes where msg_type like '%validator%'

)

-- select tx_sender, vadd from (

-- select tx_sender , TX:body:messages[0]:validator_address::string as vadd

-- from terra.core.fact_transactions a join tx b on a.tx_id = b.tx_id

-- )group by 1,2

select * from tx limit 10

-- select * from terra.core.fact_transactions where tx_id ='DEA707ECBA2D4952FD4001782D36D7F6568991FD75F1501CAF1338D5FE11A770'

Run a query to Download Data

flipside