cloudr3n2023-11-01 11:16 PM
    Updated 2023-11-02
    select
    block_timestamp,
    tx_id,
    attribute_value,
    parse_json(attribute_value) as value1,
    parse_json(value1:receiver) as value2,
    value2:autopilot:stakeibc as value3,
    value3:action
    from
    cosmos.core.fact_msg_attributes
    where
    tx_id = '4689EABCF9D95DB4AB30FDE103069BA079EDA7DAA249C84438D4F053D7DF0CC3'
    and msg_type = 'send_packet'
    and attribute_key = 'packet_data'
    /*
    stosmosis:
    select * from osmosis.core.fact_tx_body_msgs
    where tx_id='71E06B05D7CCC4E2686017F26FC359440235B1079BDE11C637CB30D3FC210774'
    stATOM:
    select
    block_timestamp,
    tx_id,
    attribute_value
    from
    cosmos.core.fact_msg_attributes
    where --tx_id='4689EABCF9D95DB4AB30FDE103069BA079EDA7DAA249C84438D4F053D7DF0CC3'
    1=1
    and msg_type='send_packet'
    and attribute_key='packet_data''
    {"amount":"100000","denom":"uatom",
    "receiver":"{\
    "autopilot\":{\
    "stakeibc\":{\
    "stride_address\":\"stride1c504ex0lsprwskhecynwk5dyfk2h0za7x0elfe\",\"action\":\"LiquidStake\"
    Run a query to Download Data