flipside

    Axelar Bridge | One Time Users Blockchain Environment
    pandaAxelar Bridge | One Time Users Blockchain Environment
    Updated 2022-11-25

    WITH user_Table AS
    (
    SELECT
    TX_ID as tx,
    ATTRIBUTE_VALUE as user_ID
    FROM
    AXELAR.CORE.FACT_MSG_ATTRIBUTES
    WHERE
    BLOCK_TIMESTAMP::date >= '2022-11-01'
    AND
    ATTRIBUTE_KEY = 'spender'
    ),

    desination_chain_Table as
    (
    SELECT
    TX_ID as tx,
    ATTRIBUTE_VALUE as blockchain
    FROM
    AXELAR.CORE.FACT_MSG_ATTRIBUTES
    WHERE
    tx IN (SELECT tx FROM user_Table)
    AND
    ATTRIBUTE_KEY = 'destinationChain'
    ),

    source_chain_Table as
    (
    SELECT
    TX_ID as tx,
    ATTRIBUTE_VALUE as blockchain
    FROM
    AXELAR.CORE.FACT_MSG_ATTRIBUTES
    WHERE
    tx IN (SELECT tx FROM user_Table)
    Run a query to Download Data