azerbaijanUntitled Query
    Updated 2022-11-25
    -- Forked from Ali3N
    with destination_chains as (
    select block_timestamp, tx_id, attribute_value as Destination_Chain
    from axelar.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and attribute_key = 'destinationChain'),

    Destinatin_users as (
    select block_timestamp,tx_id,attribute_value as Destination_User
    from axelar.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and attribute_key = 'destinationAddress'
    and tx_id in (select tx_id from destination_chains)),

    Origin_Chain as (
    select block_timestamp,
    tx_id,
    attribute_value as Origin_Chain
    from axelar.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and attribute_key = 'sourceChain'
    and tx_id in (select tx_id from destination_chains)),

    Origin_User as (
    select block_timestamp,
    tx_id,
    attribute_value as Origin_User
    from axelar.core.fact_msg_attributes
    where tx_succeeded = 'TRUE'
    and attribute_key = 'sender'
    and tx_id in (select tx_id from destination_chains)),

    Bridges as (
    select block_timestamp,
    tx_id,
    attribute_value
    Run a query to Download Data